Quest6_database_mysql

wild_db_quest2.sql

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

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

SELECT firstname, lastname, enrollment_date 
FROM wizard 
JOIN player 
  ON wizard.id = player.wizard_id 
JOIN team
  ON player.team_id = team.id 
WHERE team.name = 'Gryffindor' AND DAYOFWEEK(enrollment_date) = 2 
ORDER BY enrollment_date ;