mysql> CREATE TABLE Logins (
    ->     login_id INT AUTO_INCREMENT PRIMARY KEY,
    ->     user_id INT,
    ->     timestamp DATETIME,
    ->     ip_address VARCHAR(50),
    ->     FOREIGN KEY (user_id) REFERENCES Loggers(user_id)
    -> );
Query OK, 0 rows affected (0.04 sec)

mysql> show tables;
+------------------+
| Tables_in_dkf816 |
+------------------+
| Loggers          |
| Logins           |
+------------------+
2 rows in set (0.00 sec)

mysql> INSERT INTO Loggers (first_name, last_name, username, password, dob, avatar_url) 
    -> VALUES 
    -> ('Jane', 'Doe', 'jd999', 'abc12345', '1990-08-15', 'abc.jpeg'),
    -> ('John', 'Doe', 'jd101', '123abcd', '1992-09-01', 'picture.jpeg');
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> INSERT INTO Logins (user_id, timestamp, ip_address) 
    -> VALUES 
    -> (1, '2022-05-05 14:00:00', '999.999.999.100'),
    -> (2, '2022-02-04 12:30:00', '999.999.999.101'),
    -> (1, '2022-06-10 08:30:00', '999.999.999.100'),
    -> (1, '2022-06-11 10:15:02', '999.999.999.100'),
    -> (2, '2022-08-15 09:15:31', '999.999.999.101'),
    -> (2, '2022-08-16 21:00:00', '999.999.999.101'),
    -> (1, '2022-08-16 21:01:00', '999.999.999.101');
Query OK, 7 rows affected (0.01 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> UPDATE Loggers 
    -> SET username = 'jd@uregina.ca' 
    -> WHERE user_id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT Loggers.user_id, Loggers.first_name, Loggers.last_name, COUNT(Logins.user_id) AS login_count
    -> FROM Loggers
    -> JOIN Logins ON Loggers.user_id = Logins.user_id
    -> WHERE Loggers.username = 'jd@uregina.ca' AND Loggers.password = 'abc12345'
    -> GROUP BY Loggers.user_id, Loggers.first_name, Loggers.last_name;
+---------+------------+-----------+-------------+
| user_id | first_name | last_name | login_count |
+---------+------------+-----------+-------------+
|       1 | Jane       | Doe       |           4 |
+---------+------------+-----------+-------------+
1 row in set (0.00 sec)

mysql> SELECT timestamp, ip_address
    -> FROM Logins
    -> WHERE user_id = 1
    -> ORDER BY timestamp DESC
    -> LIMIT 3;
+---------------------+-----------------+
| timestamp           | ip_address      |
+---------------------+-----------------+
| 2022-08-16 21:01:00 | 999.999.999.101 |
| 2022-06-11 10:15:02 | 999.999.999.100 |
| 2022-06-10 08:30:00 | 999.999.999.100 |
+---------------------+-----------------+
3 rows in set (0.01 sec)