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
[{'Publisher': 'Alyson', 'count(*)': 3}, {'Publisher': 'Banned Books', 'count(*)': 2}, {'Publisher': 'Crossing Press', 'count(*)': 1}, {'Publisher': 'International Polygonics', 'count(*)': 1}, {'Publisher': 'Mysterious Press', 'count(*)': 1}, {'Publisher': 'Naiad Press', 'count(*)': 2}, {'Publisher': "St. Martin's Press", 'count(*)': 1}, {'Publisher': 'William Morrow', 'count(*)': 1}]