Created
May 18, 2019 21:04
-
-
Save bapHyv/10355184a9af4aaf82427c998b49aa8c to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> select count(*) as nb_player, team.name from player inner join team on team.id=player.team_id group by team_id order by nb_player desc; | |
| +-----------+------------+ | |
| | nb_player | name | | |
| +-----------+------------+ | |
| | 36 | Gryffindor | | |
| | 21 | Slytherin | | |
| | 15 | Ravenclaw | | |
| | 12 | Hufflepuff | | |
| +-----------+------------+ | |
| 4 rows in set (0.01 sec) | |
| mysql> select count(*) as nb_player, team.name from player inner join team on team.id=player.team_id group by team_id having nb_player>14 order by name asc; | |
| +-----------+------------+ | |
| | nb_player | name | | |
| +-----------+------------+ | |
| | 36 | Gryffindor | | |
| | 15 | Ravenclaw | | |
| | 21 | Slytherin | | |
| +-----------+------------+ | |
| 3 rows in set (0.01 sec) | |
| mysql> select team.name as team_name, concat(wizard.firstname, ' ', wizard.lastname) as wizard_name from player join wizard on wizard.id=player.wizard_id join team on team.id=player.team_id where dayofweek(enrollment_date)=1 having team.name="Gryffindor" order by enrollment_date asc; | |
| +------------+------------------+ | |
| | team_name | wizard_name | | |
| +------------+------------------+ | |
| | Gryffindor | Frank Longbottom | | |
| | Gryffindor | Ronald Weasley | | |
| | Gryffindor | Dean Thomas | | |
| | Gryffindor | Fred Weasley | | |
| +------------+------------------+ | |
| 4 rows in set (0.00 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment