Task: Text to Code
Input (English): How many books fall into each category?
Output (English): SELECT category ,  count(*) FROM book_club GROUP BY category