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
[{'name': 'Action', 'category_id': 1, 'count(*)': 64}, {'name': 'Animation', 'category_id': 2, 'count(*)': 66}, {'name': 'Children', 'category_id': 3, 'count(*)': 60}, {'name': 'Classics', 'category_id': 4, 'count(*)': 57}, {'name': 'Comedy', 'category_id': 5, 'count(*)': 58}, {'name': 'Documentary', 'category_id': 6, 'count(*)': 68}, {'name': 'Drama', 'category_id': 7, 'count(*)': 62}, {'name': 'Family', 'category_id': 8, 'count(*)': 69}, {'name': 'Foreign', 'category_id': 9, 'count(*)': 73}, {'name': 'Games', 'category_id': 10, 'count(*)': 61}, {'name': 'Horror', 'category_id': 11, 'count(*)': 56}, {'name': 'Music', 'category_id': 12, 'count(*)': 51}, {'name': 'New', 'category_id': 13, 'count(*)': 63}, {'name': 'Sci-Fi', 'category_id': 14, 'count(*)': 61}, {'name': 'Sports', 'category_id': 15, 'count(*)': 74}, {'name': 'Travel', 'category_id': 16, 'count(*)': 57}]