SQL Top 3 Users by Month | Dataford Interview Questions

Write a SQL query to find the top 3 most active users by number of sessions in each month.

Use valid users and sessions with non-null timestamps. Break ties by ascending user_id.

Output

One row per qualifying user and month
Columns: month, user_id, user_name, session_count, and monthly_rank
Include no more than three users per month, ordered by month, then monthly_rank

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name

sessions

Column	Type	Description
session_idPK	INT	Unique session identifier
user_id	INT	User associated with the session
started_at	TIMESTAMP	Timestamp when the session started

Your question is SQL Top 3 Users by Month. 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.