SQL Top 3 Users by Month

MediumSQL · PostgreSQL

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

Tablesuserssessions

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.