SELECT id_genre, COUNT(*) as  "nombre films" FROM film WHERE id_Genre IS NOT NULL GROUP BY id_genre WITH ROLLUP;