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

```sql
SELECT category, COUNT(*) as row_count