CREATE TABLE book_club (category VARCHAR(255))
Show all book categories and the number of books in each category.
    
SQL: SELECT category, COUNT(*) FROM book_club GROUP BY category