How many films are there in each category? List the genre name, genre id and the count.
create table film_category (category_id varchar, PRIMARY KEY (category_id)); create table category (name varchar, category_id varchar, PRIMARY KEY (name))
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