Bases de Données Relationnelles et SQL
pasbien.sql
SELECT c.nom AS club, AVG(j.elo) AS moyenne_elo FROM joueuse j INNER JOIN club c
USING (id_club) WHERE mail IS NOT NULL GROUP BY c.nom HAVING AVG(j.elo) > 2000 ORDER BY 2 DESC;
bien.sql
SELECT c.nom AS club,
AVG(j.elo) AS moyenne_elo
FROM joueuse j
INNER JOIN club c USING (id_club)
WHERE j.mail IS NOT NULL
GROUP BY c.nom
HAVING AVG(j.elo) > 2000
ORDER BY 2 DESC;