Top Five Workspace Query | Dataford Interview Questions

Write a SQL query to find the top five most frequently used workspaces.

Treat a workspace as used when it has a confirmed reservation. Return the five workspaces with the highest confirmed reservation counts, including a workspace with zero confirmed reservations when necessary to complete the top five.

Output

One row per workspace, with workspace_id, workspace_name, and confirmed_reservation_count
Include only the top five workspaces
Order by reservation count descending, then workspace_id ascending to break ties

Schema

workspaces

Column	Type	Description
workspace_idPK	INT	Unique identifier for a WeWork workspace
workspace_name	VARCHAR(100)	Display name of the workspace

reservations

Column	Type	Description
reservation_idPK	INT	Unique reservation identifier
workspace_id	INT	Workspace associated with the reservation
status	VARCHAR(20)	Reservation status

Your question is Top Five Workspace Query. 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