Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COU_ANNEE AS "Année Course", PER_GENRE AS "Genre (Catégorie)", COUNT(COU_PER_ID) AS "Nombre Candidats" 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_SO%"
- AND PER_GENRE LIKE "%F%"
- AND COU_ANNEE = 2014
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement