ludovic.deneuville@ensai.fr
<...>
[...]
;
-- Ce qui vient ensuite est commenté
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 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 ORDER BY 2 DESC;