Database: book_press
Question: Find the number of books for each series.
SQL:
SELECT count(*) ,  book_series FROM book GROUP BY book_series