Your question is Top Chatters Message Frequency. Start with the requirements and the three tables 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.
Twitch wants to identify the most active chatters in each channel during the first week of August 2026. Write a PostgreSQL query using Twitch channel and chat event data to rank registered chatters by message frequency.
message events from August 1 through August 7, 2026, inclusive.| Column | Type | Description |
|---|---|---|
| channel_idPK | INT | Twitch channel identifier |
| channel_name | VARCHAR(100) | Channel display name |
| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Registered Twitch user identifier |
| username | VARCHAR(50) | Twitch username |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Chat event identifier |
| channel_id | INT | Referenced Twitch channel |
| user_id | INT | User who generated the event |
| event_type | VARCHAR(30) | Event category |
| event_time | TIMESTAMP | Time at which the event occurred |