Sold-Out Events
Medium
Event Ticketing
Return events whose sold tickets equal their capacity.
Table schema
Events(id INT PRIMARY KEY, name VARCHAR(10), capacity INT)
Tickets(id INT PRIMARY KEY, event_id INT, buyer VARCHAR(10), price INT)Sample data
Events
id | name | capacity
1 | Rock | 3
2 | Jazz | 5
3 | Folk | 2
Tickets
id | event_id | buyer | price
1 | 1 | Ann | 100
2 | 1 | Bob | 100
3 | 1 | Cy | 120
4 | 2 | Ann | 80
5 | 2 | Ann | 80
6 | 2 | Ann | 80
7 | 3 | Dee | 50
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.