Advertisement
copy_pasta

Untitled

Nov 19th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | None | 0 0
  1. SELECT SUM(cou_temps) AS Temps, EQU_NOM AS "Nom Equipe", PER_GENRE AS "Genre (catégorie)", PER_NOM AS "Nom Prenom"
  2. FROM cc_course
  3. JOIN cc_personne ON COU_PER_ID = PER_ID
  4. JOIN cc_equipe ON EQU_ID = PER_EQU_ID
  5. WHERE EQU_NOM LIKE "%HES%"
  6. AND PER_GENRE LIKE "%F%"
  7. GROUP BY EQU_NOM, PER_NOM
  8. ORDER BY Temps
  9. LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement