Database: book_press
Question: How many books does each book series have? Return the counts and book series.
SQL:
SELECT count(*) ,  book_series FROM book GROUP BY book_series