Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE film_category (category_id VARCHAR)
TABLE: CREATE TABLE category (name VARCHAR, category_id VARCHAR)

### Question ###
How many films are there in each category? List the genre name, genre id and the count.

### Accurate SQL ###

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