Confirmed or Waitlisted Webinar Seats

Problem

Tables: `sessions`, `registrations`

**sessions**
| Column Name | Type |
|---|---|
| session_id | int |
| seat_limit | int |

`session_id` is the primary key. `seat_limit` is how many confirmed seats the webinar offers.

**registrations**
| Column Name | Type |
|---|---|
| attendee_id | int |
| session_id | int |
| registered_at | datetime |

`attendee_id` is the primary key. Each row is one person registering for one session at a specific time; registration times within a session are distinct.

Seats are filled first-come-first-served by `registered_at`. The earliest `seat_limit` registrations of a session are `Confirmed`; everyone after that is `Waitlist`. Return each `attendee_id` and their `seat_status`, ordered by `attendee_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns attendee_id, seat_status.

Starter code (SQL)

SELECT *
FROM sessions;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard