Advertisement
copy_pasta

Untitled

Nov 19th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.30 KB | None | 0 0
  1. SELECT PER_NOM AS "Nom Prenom", MIN((SELECT SUM(COU_TEMPS) FROM cc_course WHERE COU_PER_ID = pers.PER_ID)) AS Temps
  2. FROM cc_personne pers JOIN cc_course ON PER_ID = COU_PER_ID
  3. WHERE PER_ID = COU_PER_ID
  4. AND COU_ANNEE = 2014
  5. AND PER_GENRE LIKE "%H%"  
  6. GROUP BY PER_NOM, PER_ID
  7. ORDER BY Temps ASC
  8. LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement