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