The community team wants to identify power reviewers per product category. Using the reviews and products tables, return category, user_id, and review_count for the user(s) with the most reviews in each category, ordered by category. Include ties.
products
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| category | TEXT |
reviews
| column | type |
|---|---|
| id | INTEGER |
| product_id | INTEGER |
| user_id | INTEGER |
| rating | INTEGER |
| created_at | DATE |
Electronics: user 1 reviews 3 products, user 2 reviews 1. Books: user 2 reviews 2, user 3 reviews 2 (tie).
| category | user_id | review_count |
|---|---|---|
| Books | 2 | 2 |
| Books | 3 | 2 |
| Electronics | 1 | 3 |