Buffering Users SQL Query | Dataford Interview Questions

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.

Requirements

Join Twitch users to their event records.
Calculate each user's total watch time in seconds from watch events.
Count each user's buffering events and retain only users with more than three.
Return up to ten users ordered by total watch time descending, using user_id as a deterministic tie-breaker.

Schema

twitch_users

Column	Type	Description
user_idPK	INT	Unique Twitch user identifier
username	VARCHAR(50)	Twitch username

twitch_user_events

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

Your question is Buffering Users SQL Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem