Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SUM(cou_temps) AS Temps, EQU_NOM AS "Nom Equipe", PER_GENRE AS "Genre (catégorie)", PER_NOM AS "Nom Prenom"
- FROM cc_course
- JOIN cc_personne ON COU_PER_ID = PER_ID
- JOIN cc_equipe ON EQU_ID = PER_EQU_ID
- WHERE EQU_NOM LIKE "%HES%"
- AND PER_GENRE LIKE "%F%"
- GROUP BY EQU_NOM, PER_NOM
- ORDER BY Temps
- LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement