CREATE TABLE book_club (category VARCHAR)

Show all book categories and the number of books in each category.
SELECT category, COUNT(*) FROM book_club GROUP BY category
SELECT "category", COUNT(*) FROM "book_club" GROUP BY "category"