Database: culture_company
Question: Show all book categories and the number of books in each category.
SQL:
SELECT category ,  count(*) FROM book_club GROUP BY category