SQL Top 10 Active Users | Dataford Interview Questions

Write a SQL query to find the top 10 users with the highest activity in the last month.

Treat activity as the number of activity events during the previous calendar month. Return users with at least one qualifying event.

Output

One row per user, with user_id, username, and activity_count.
Return at most 10 users, ordered by activity_count descending and user_id ascending for ties.

users

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

activity_events

Column	Type	Description
activity_idPK	INT	Unique activity event identifier
user_id	INT	User associated with the activity event
activity_date	DATE	Calendar date of the activity
event_type	VARCHAR(50)	Type of activity performed

Your question is SQL Top 10 Active Users. 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.