SQL Top 5 Conference Rooms | Dataford Interview Questions

Write a SQL query to find the top 5 most frequently used conference rooms from a table of raw meeting start and end times.

Count each valid meeting record once. Exclude records missing a room or either timestamp, and exclude records whose end time is not after their start time.

Output

One row per room, with room_name and meeting_count.
Return at most five rooms, ordered by meeting count descending, then room name ascending for ties.

Schema

meeting_records

Column	Type	Description
meeting_idPK	INT	Unique meeting record identifier
room_name	VARCHAR(100)	Conference room name
start_time	TIMESTAMP	Meeting start timestamp
end_time	TIMESTAMP	Meeting end timestamp

Your question is SQL Top 5 Conference Rooms. Start with the requirements and the one table 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