SELECT PER_GENRE "Genre (Catégorie)", SUM(COU_TEMPS - (SELECT AVG(COU_TEMPS) FROM cc_course))/COUNT(*) AS "Ecart Moyen"
FROM cc_course
JOIN cc_personne ON COU_PER_ID = PER_ID
WHERE PER_GENRE LIKE "%H%"
OR PER_GENRE LIKE "%F%"
GROUP BY PER_GENRE