Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LIE_NOM AS "Nom Lieu", COUNT(LIE_NOM) AS "Nombre Candidats"
- FROM cc_lieu
- JOIN cc_personne ON PER_LIE_ID = LIE_ID
- JOIN cc_course ON COU_PER_ID = PER_ID
- WHERE COU_ANNEE = '2014'
- GROUP BY LIE_NOM
- ORDER BY COUNT(LIE_NOM) DESC
- LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement