Top 50 Rows Query | Dataford Interview Questions

Cvent's Event Management platform needs a quick operational view of the most recent event registrations. Write a PostgreSQL query that returns the top 50 registrations, where top means the newest registration timestamp.

Requirements

Return registration ID, attendee name, event name, registration status, and registration timestamp.
Sort registrations from newest to oldest, using registration ID as a deterministic tie-breaker, and return no more than 50 rows.

Schema

event_registrations

Column	Type	Description
registration_idPK	INTEGER	Unique registration identifier
attendee_name	VARCHAR(150)	Name of the registered attendee
event_name	VARCHAR(200)	Cvent event name
registration_status	VARCHAR(30)	Current registration status
registered_at	TIMESTAMPTZ	Timestamp when the registration was created

Your question is Top 50 Rows Query. 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

Requirements

Return registration ID, attendee name, event name, registration status, and registration timestamp.
Sort registrations from newest to oldest, using registration ID as a deterministic tie-breaker, and return no more than 50 rows.

Schema

event_registrations

Column	Type	Description
registration_idPK	INTEGER	Unique registration identifier
attendee_name	VARCHAR(150)	Name of the registered attendee
event_name	VARCHAR(200)	Cvent event name
registration_status	VARCHAR(30)	Current registration status
registered_at	TIMESTAMPTZ	Timestamp when the registration was created

Your question is Top 50 Rows Query. 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.