Advertisement
Guest User

Untitled

a guest
Nov 18th, 2017
68
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 = '2015'
  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