CREATE TABLE culture_company (Company_name CLOB, Type CLOB, Incorporated_in CLOB, Group_Equity_Shareholding FLOAT, book_club_id CLOB, movie_id CLOB)
CREATE TABLE movie (movie_id NUMBER, Title CLOB, Year NUMBER, Director CLOB, Budget_million FLOAT, Gross_worldwide NUMBER)
CREATE TABLE book_club (book_club_id NUMBER, Year NUMBER, Author_or_Editor CLOB, Book_Title CLOB, Publisher CLOB, Category CLOB, Result CLOB)

Show all book categories and the number of books in each category, and list by the total number in asc please.
SELECT Category, COUNT(*) FROM book_club GROUP BY Category ORDER BY COUNT(*)
SELECT "Category", COUNT(*) FROM "book_club" GROUP BY "Category" ORDER BY COUNT(*)