mysql> SELECT team.name, COUNT(*) AS nb_player FROM player JOIN team ON team.id=player.team_id GROUP BY name ORDER BY nb_player DESC;

+------------+-----------+
| name       | nb_player |
+------------+-----------+
| Gryffindor |        36 |
| Slytherin  |        21 |
| Ravenclaw  |        15 |
| Hufflepuff |        12 |
+------------+-----------+
4 rows in set (0,01 sec)

mysql> SELECT team.name, COUNT(*) AS nb_player FROM player JOIN team ON team.id=player.team_id GROUP BY name HAVING nb_player > 13;

+------------+-----------+
| name       | nb_player |
+------------+-----------+
| Gryffindor |        36 |
| Ravenclaw  |        15 |
| Slytherin  |        21 |
+------------+-----------+
3 rows in set (0,01 sec)

mysql> SELECT firstname, enrollment_date FROM player JOIN team ON team.id=player.team_id JOIN wizard ON wizard.id=player.wizard_id WHERE team_id = 1 AND DAYNAME(enrollment_date)= 'monday' ORDER BY enrollment_date ASC;

+-----------+-----------------+
| firstname | enrollment_date |
+-----------+-----------------+
| George    | 1991-08-26      |
| Alice     | 1992-02-17      |
| Cadogan   | 1993-01-04      |
| Godric    | 1993-08-30      |
| Sirius    | 1994-01-10      |
| Aberforth | 1995-04-24      |
| Augusta   | 1999-10-25      |
+-----------+-----------------+
7 rows in set (0,01 sec)