Show all book categories and the number of books in each category, list in asc by the bar.
CREATE TABLE culture_company (
    Company_name text,
    Type text,
    Incorporated_in text,
    Group_Equity_Shareholding real,
    book_club_id text,
    movie_id text
)

CREATE TABLE book_club (
    book_club_id int,
    Year int,
    Author_or_Editor text,
    Book_Title text,
    Publisher text,
    Category text,
    Result text
)

CREATE TABLE movie (
    movie_id int,
    Title text,
    Year int,
    Director text,
    Budget_million real,
    Gross_worldwide int
)
SELECT Category, COUNT(*) FROM book_club GROUP BY Category ORDER 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: Show all book categories and the number of books in each category, list in asc by the bar. ### Input: CREATE TABLE culture_company (
    Company_name text,
    Type text,
    Incorporated_in text,
    Group_Equity_Shareholding real,
    book_club_id text,
    movie_id text
)

CREATE TABLE book_club (
    book_club_id int,
    Year int,
    Author_or_Editor text,
    Book_Title text,
    Publisher text,
    Category text,
    Result text
)

CREATE TABLE movie (
    movie_id int,
    Title text,
    Year int,
    Director text,
    Budget_million real,
    Gross_worldwide int
) ### Response: SELECT Category, COUNT(*) FROM book_club GROUP BY Category ORDER BY Category