How many books fall into each category?
CREATE TABLE movie (
    movie_id number,
    title text,
    year number,
    director text,
    budget_million number,
    gross_worldwide number
)

CREATE TABLE culture_company (
    company_name text,
    type text,
    incorporated_in text,
    group_equity_shareholding number,
    book_club_id text,
    movie_id text
)

CREATE TABLE book_club (
    book_club_id number,
    year number,
    author_or_editor text,
    book_title text,
    publisher text,
    category text,
    result text
)
SELECT category, COUNT(*) FROM book_club GROUP BY category
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many books fall into each category? ### Input: CREATE TABLE movie (
    movie_id number,
    title text,
    year number,
    director text,
    budget_million number,
    gross_worldwide number
)

CREATE TABLE culture_company (
    company_name text,
    type text,
    incorporated_in text,
    group_equity_shareholding number,
    book_club_id text,
    movie_id text
)

CREATE TABLE book_club (
    book_club_id number,
    year number,
    author_or_editor text,
    book_title text,
    publisher text,
    category text,
    result text
) ### Response: SELECT category, COUNT(*) FROM book_club GROUP BY category