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