1. Write a query that lists the five humans who have played the most rps matches, and how many they each have played.  

+----------+-------------+
| human    | num_matches |
+----------+-------------+
| leek0    |        1388 |
| bahao0   |         114 |
| doylear0 |         106 |
| sulliwj0 |         105 |
| bhandu0  |          91 |
+----------+-------------+

(Your results might look different from the above because the database might have changed between when I ran this query and when you did. This note applies to probably all the exercises on this list)

2. Write a query that lists each human player, along with the time and date of that player's first match and their most recent match.

+----------+---------------------+---------------------+
| human    | first_match         | most_recent         |
+----------+---------------------+---------------------+
| adejuoj0 | 2024-01-18 20:09:11 | 2024-01-18 20:11:51 |
| bahao0   | 2024-01-18 09:59:35 | 2024-01-19 08:34:07 |
| bellijh0 | 2024-01-19 07:58:51 | 2024-01-19 08:03:05 |
| bertct0  | 2024-01-18 13:44:33 | 2024-01-18 13:46:23 |
| bhandu0  | 2024-01-18 11:51:50 | 2024-01-18 11:58:11 |
| carpeca0 | 2024-01-18 12:24:04 | 2024-01-18 12:47:03 |
| darbnjr0 | 2024-01-18 14:10:42 | 2024-01-18 14:16:58 |
| ddrinen  | 2024-01-18 08:56:26 | 2024-01-18 09:35:41 |
| doylear0 | 2024-01-18 18:31:47 | 2024-01-19 08:34:37 |
| hardibc0 | 2024-01-18 15:42:47 | 2024-01-18 15:45:49 |
| jacksbc0 | 2024-01-19 08:01:14 | 2024-01-19 08:02:03 |
| jakoba0  | 2024-01-18 18:53:44 | 2024-01-18 18:56:37 |
| leek0    | 2024-01-18 15:10:36 | 2024-01-18 15:32:09 |
| manacjs0 | 2024-01-18 09:55:25 | 2024-01-18 10:00:13 |
| ricekg0  | 2024-01-18 13:33:44 | 2024-01-18 13:34:27 |
| sulliwj0 | 2024-01-19 00:04:21 | 2024-01-19 08:34:09 |
+----------+---------------------+---------------------+

3.  List the 3 human players who have played the most matches against bot02.

+----------+--------------+
| human    | num_vs_bot02 |
+----------+--------------+
| leek0    |          239 |
| darbnjr0 |           19 |
| bhandu0  |           18 |
+----------+--------------+

4.  List the 3 human players who have had the most wins against bot02.

+----------+--------------+
| human    | num_vs_bot02 |
+----------+--------------+
| leek0    |           80 |
| doylear0 |            7 |
| adejuoj0 |            6 |
+----------+--------------+

5.  List the 3 players who have the best winning percentage (that is, wins divided by total matches) against bot04. Only include players who have played at least 5 matches against bot04.  HINT:  consider the average of the player_1_win column.  Think about why that works.

+----------+----------------------+------------------+
| human    | num_matches_vs_bot04 | win_pct_vs_bot04 |
+----------+----------------------+------------------+
| manacjs0 |                    5 |           0.6000 |
| hardibc0 |                    7 |           0.4286 |
| jakoba0  |                   11 |           0.3636 |
+----------+----------------------+------------------+