SELECT publisher ,  count(*) FROM book_club GROUP BY publisher
Show all publishers and the number of books for each publisher.
CREATE TABLE "book_club" (
"book_club_id" int,
"Year" int,
"Author_or_Editor" text,
"Book_Title" text,
"Publisher" text,
"Category" text,
"Result" text,
PRIMARY KEY ("book_club_id")
);
CREATE TABLE "movie" (
"movie_id" int,
"Title" text,
"Year" int,
"Director" text,
"Budget_million" real,
"Gross_worldwide" int,
PRIMARY KEY("movie_id")
);
CREATE TABLE "culture_company" (
"Company_name" text,
"Type" text,
"Incorporated_in" text,
"Group_Equity_Shareholding" real,
"book_club_id" text,
"movie_id" text,
PRIMARY KEY("Company_name"),
FOREIGN KEY ("book_club_id") REFERENCES "book_club"("book_club_id"),
FOREIGN KEY ("movie_id") REFERENCES "movie"("movie_id")
);
INSERT INTO  "book_club" VALUES (1, "1989","Michael Nava","Goldenboy","Alyson","Gay M/SF","Won [A ]");
INSERT INTO  "movie" VALUES (1, "The Boondock Saints","1999","Troy Duffy","6","30471");
INSERT INTO  "culture_company" VALUES ("Culture China","Corporate","China","18.77",1,2);