Your question is Total Records by Category. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Microsoft analysts are reviewing product telemetry records across Microsoft 365 and Azure experiences. Write a PostgreSQL query that reports how many records belong to each category.
category and return one row per category, including records where the category is NULL.NULL category last.| Column | Type | Description |
|---|---|---|
| event_idPK | INTEGER | Unique telemetry record identifier |
| category | VARCHAR(50) | Microsoft product or experience category |
| event_name | VARCHAR(100) | Name of the recorded event |
| event_date | DATE | Date on which the event was recorded |