SQL Power User Identification | Dataford Interview Questions

Given a table of user event logs, how would you write a query to identify power users based on session frequency and duration? For this exercise, analyze events during January 2025 and treat a user as a power user when they have at least 3 sessions and an average session duration of at least 20 minutes. Derive each session's duration from its first and last event timestamps.

Output

Return one row per qualifying user.
Include user_id, session_count, and avg_session_duration_minutes.
Order by session count descending, average duration descending, then user ID ascending.

Schema

user_event_logs

Column	Type	Description
event_idPK	INT	Unique identifier for the event
user_id	INT	Identifier of the user who generated the event
session_id	VARCHAR(30)	Identifier shared by events in the same session
event_type	VARCHAR(40)	Type of user event
event_timestamp	TIMESTAMPTZ	Timestamp when the event occurred

Your question is SQL Power User Identification. Start with the requirements and the one table 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

Output

Return one row per qualifying user.
Include user_id, session_count, and avg_session_duration_minutes.
Order by session count descending, average duration descending, then user ID ascending.

Schema

user_event_logs

Column	Type	Description
event_idPK	INT	Unique identifier for the event
user_id	INT	Identifier of the user who generated the event
session_id	VARCHAR(30)	Identifier shared by events in the same session
event_type	VARCHAR(40)	Type of user event
event_timestamp	TIMESTAMPTZ	Timestamp when the event occurred

Your question is SQL Power User Identification. Start with the requirements and the one table 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.