Count the number of books in each genre. Show genre and a count named books.

Answer

SELECT genre, COUNT(*) AS books FROM books GROUP BY genre;