Show each genre and its book count, but only for genres with at least 2 books.

Answer

SELECT genre, COUNT(*) AS books FROM books GROUP BY genre HAVING COUNT(*) >= 2;