gistfile1.txt

-- Question 1 :

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

-- Question 2 :

SELECT `name`, COUNT(*) AS nb_player
FROM `player` INNER JOIN `team` 
ON team.id = team_id
GROUP BY `team_id`
HAVING nb_player > 14
ORDER BY `name`;

-- Question 3 :

SELECT `last_name`, `first_name`
FROM `player` INNER JOIN `wizard`
ON player.id = wizard.id
WHERE date_format(`enrollment_date`, '%a') = 'Mon' AND `team_id` = 1
ORDER BY `enrollment_date` ASC;