Interview Core Track · Easy · 15 min
Most Attended Webinar Sessions
Marketing wants the three webinar sessions with the largest verified audiences. Return webinar_id, topic, and attendee_count, ordered by attendee_count desce...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a LinkedIn-tagged business scenario.
Approach
Use this track to improve speed, edge-case handling, and accuracy under timed conditions.
Company context
Company labels are directional practice context, not official interview guidance.
Marketing wants the three webinar sessions with the largest verified audiences. Return webinar_id, topic, and attendee_count, ordered by attendee_count descending and then webinar_id.
webinars
| webinar_id | topic |
|---|---|
| 1 | SQL Basics |
| 2 | Analytics Dashboards |
| 3 | Python Tips |
| 4 | Interview Prep |
webinar_attendance
| attendance_id | webinar_id | attendee_id |
|---|---|---|
| 10 | 1 | 100 |
| 11 | 1 | 101 |
| 12 | 1 | 102 |
| 13 | 2 | 100 |
| 14 | 2 | 103 |
| 15 | 3 | 104 |
| 16 | 3 | 105 |
| 17 | 3 | 106 |
| 18 | 3 | 107 |
| 19 | 4 | 108 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.