Tickets Sold per Event

Return each event name with the number of tickets sold (0 if none). Order by name.

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