Top 50 Rows Query

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Top 50 Rows Query. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

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

Tablesevent_registrations

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results