SELECT category ,  count(*) FROM book_club GROUP BY category
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
Show all book categories and the number of books in each category .