Cacher is the code snippet organizer for pro developers

--To count aggregated rows with common values use the GROUP BY keywords:

SELECT category FROM products Group By category;


SELECT category, COUNT(*) FROM products Group By category;


-- count all books in each genre
select genre, COUNT(id) as "genre_count" FROM books group by genre;