Top Users by Shift Count | Dataford Interview Questions

Write a SQL query to find the top three users by shift count.

Count all shifts associated with each user. Include users with no shifts when calculating counts, but return only the three users with the highest counts.

Output

One row per selected user with user_id, full_name, and shift_count
Return exactly three rows
Sort by shift_count descending, then user_id ascending to break ties

Schema

users

Column	Type	Description
user_idPK	INT	Unique identifier for the user
full_name	VARCHAR(100)	User's full name

shifts

Column	Type	Description
shift_idPK	INT	Unique identifier for the shift
user_id	INT	User assigned to the shift
shift_date	DATE	Date on which the shift occurred

Your question is Top Users by Shift Count. 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