SELECT T2.name ,  T1.category_id ,  count(*) FROM film_category AS T1 JOIN category AS T2 ON T1.category_id  =  T2.category_id GROUP BY T1.category_id
How many films are there in each category? List the genre name, genre id and the count.
SELECT T2.name , T1.category_id , count ( * ) FROM film_category AS T1 JOIN category AS T2 ON T1.category_id = T2.category_id GROUP BY T1.category_id
select t2 . name , t1 . category_id , count ( * ) from film_category as t1 join category as t2 on t1 . category_id = t2 . category_id group by t1 . category_id
How many films are there in each category ? List the genre name , genre id and the count .