CREATE TABLE book_club (book_club_id DECIMAL, year DECIMAL, author_or_editor TEXT, book_title TEXT, publisher TEXT, category TEXT, result TEXT)
CREATE TABLE culture_company (company_name TEXT, type TEXT, incorporated_in TEXT, group_equity_shareholding DECIMAL, book_club_id TEXT, movie_id TEXT)
CREATE TABLE movie (movie_id DECIMAL, title TEXT, year DECIMAL, director TEXT, budget_million DECIMAL, gross_worldwide DECIMAL)

How many books are there for each publisher?
SELECT publisher, COUNT(*) FROM book_club GROUP BY publisher
SELECT "publisher", COUNT(*) FROM "book_club" GROUP BY "publisher"