Here's a simple SQL query that counts rows per category:

```sql
SELECT 
    category,
    COUNT(*) AS