Advertisement
copy_pasta

Untitled

Nov 19th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. SELECT LIE_NOM AS "Nom Lieu", COUNT(LIE_NOM) AS "Nombre Candidats"
  2.     FROM cc_lieu
  3.     JOIN cc_personne ON PER_LIE_ID = LIE_ID
  4.     JOIN cc_course ON COU_PER_ID = PER_ID
  5.            WHERE COU_ANNEE = '2014'
  6.            GROUP BY LIE_NOM
  7.            ORDER BY COUNT(LIE_NOM) DESC
  8.            LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement