SQL for Top 5% Daily Users | Dataford Interview Questions

Write a SQL query to identify the top 5% of users based on daily active usage over the last quarter.

For this exercise, treat the last quarter as April 1, 2026 through June 30, 2026. Calculate each active user's average daily usage, exclude activity outside that period, and use user_id as the tie-breaker.

Output

One row per selected user with user_id, user_name, avg_daily_usage, and usage_rank.
Include only the top 5% of active users, rounded up to at least one user.
Order by usage_rank, then user_id.

Schema

users

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

user_activity

Column	Type	Description
activity_idPK	INT	Unique activity record identifier
user_id	INT	User associated with the activity
activity_date	DATE	Calendar date of recorded usage
usage_seconds	INT	Usage duration in seconds

Your question is SQL for Top 5% Daily 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.

Problem