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
What are the names and ids of the different categories, and how many films are in each?
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
What are the names and ids of the different categories , and how many films are in each ?