CREATE TABLE movie (movie_id NUMBER, title CLOB, year NUMBER, director CLOB, budget_million NUMBER, 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)
CREATE TABLE culture_company (company_name CLOB, type CLOB, incorporated_in CLOB, group_equity_shareholding NUMBER, book_club_id CLOB, movie_id CLOB)

Show all publishers and the number of books for each publisher.
SELECT publisher, COUNT(*) FROM book_club GROUP BY publisher
SELECT "publisher", COUNT(*) FROM "book_club" GROUP BY "publisher"