Show all book categories and the number of books in each category.
CREATE TABLE book_club (category VARCHAR)
SELECT category, COUNT(*) FROM book_club GROUP BY category
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE book_club (category VARCHAR) Question: Show all book categories and the number of books in each category. [/INST] SELECT category, COUNT(*) FROM book_club GROUP BY category </s>