Write a simple SQL query that counts rows per category.