CREATE TABLE inventory (inventory_id NUMBER, film_id NUMBER, store_id NUMBER, last_update TIME)
CREATE TABLE city (city_id NUMBER, city CLOB, country_id NUMBER, last_update TIME)
CREATE TABLE payment (payment_id NUMBER, customer_id NUMBER, staff_id NUMBER, rental_id NUMBER, amount NUMBER, payment_date TIME, last_update TIME)
CREATE TABLE store (store_id NUMBER, manager_staff_id NUMBER, address_id NUMBER, last_update TIME)
CREATE TABLE country (country_id NUMBER, country CLOB, last_update TIME)
CREATE TABLE film_text (film_id NUMBER, title CLOB, description CLOB)
CREATE TABLE address (address_id NUMBER, address CLOB, address2 CLOB, district CLOB, city_id NUMBER, postal_code CLOB, phone CLOB, last_update TIME)
CREATE TABLE film_category (film_id NUMBER, category_id NUMBER, last_update TIME)
CREATE TABLE film (film_id NUMBER, title CLOB, description CLOB, release_year TIME, language_id NUMBER, original_language_id NUMBER, rental_duration NUMBER, rental_rate NUMBER, length NUMBER, replacement_cost NUMBER, rating CLOB, special_features CLOB, last_update TIME)
CREATE TABLE language (language_id NUMBER, name CLOB, last_update TIME)
CREATE TABLE actor (actor_id NUMBER, first_name CLOB, last_name CLOB, last_update TIME)
CREATE TABLE customer (customer_id NUMBER, store_id NUMBER, first_name CLOB, last_name CLOB, email CLOB, address_id NUMBER, active BOOLEAN, create_date TIME, last_update TIME)
CREATE TABLE staff (staff_id NUMBER, first_name CLOB, last_name CLOB, address_id NUMBER, picture others, email CLOB, store_id NUMBER, active BOOLEAN, username CLOB, password CLOB, last_update TIME)
CREATE TABLE category (category_id NUMBER, name CLOB, last_update TIME)
CREATE TABLE film_actor (actor_id NUMBER, film_id NUMBER, last_update TIME)
CREATE TABLE rental (rental_id NUMBER, rental_date TIME, inventory_id NUMBER, customer_id NUMBER, return_date TIME, staff_id NUMBER, last_update TIME)

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" "T1" JOIN "category" "T2" ON "T1"."category_id" = "T2"."category_id" GROUP BY "T1"."category_id"