Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT PER_NOM, MIN((SELECT SUM(COU_TEMPS) FROM cc_course WHERE COU_PER_ID = pers.PER_ID)) AS Temps
- FROM cc_personne pers JOIN cc_course ON PER_ID = COU_PER_ID
- WHERE PER_ID = COU_PER_ID
- AND COU_ANNEE = 2014
- AND PER_GENRE LIKE "%H%"
- GROUP BY PER_NOM, PER_ID
- ORDER BY Temps
- LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement