Your question is Buffering Users SQL Query. Start with the requirements and the two 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 Operations wants to identify viewers who experienced frequent playback interruptions while still accumulating substantial watch time. Write a PostgreSQL query to find the top ten qualifying Twitch users.
watch events.buffering events and retain only users with more than three.user_id as a deterministic tie-breaker.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique Twitch user identifier |
| username | VARCHAR(50) | Twitch username |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| user_id | INT | User associated with the event |
| event_type | VARCHAR(20) | Event category |
| duration_seconds | INT | Watch duration in seconds, when applicable |