SELECT nom, COUNT(*) AS nb_film
FROM film
NATURAL JOIN genre
WHERE id_genre IS NOT NULL
GROUP BY id_genre
ORDER BY nb_film DESC;