Show all book categories and the number of books in each category.
CREATE TABLE book_club (
    category VARCHAR
)
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: Show all book categories and the number of books in each category. ### Input: CREATE TABLE book_club (
    category VARCHAR
) ### Response: SELECT category, COUNT(*) FROM book_club GROUP BY category