电影院想看每部电影有几条 tickets 记录，一张单也没卖的也要列出来，写 0。选出每部电影的 title 和它在 tickets 里的行数，用一个小查询来数。
| id | title | genre | minutes | rating |
|---|---|---|---|---|
| 1 | Robot Summer | family | 95 | 8 |
| 2 | Dark Lake | horror | 110 | 6 |
| 3 | Space Pals | family | 88 | 7 |
| 4 | The Long Road | drama | 142 | 9 |
| 5 | Laugh Track | comedy | 101 | 5 |
| 6 | Snow Day | comedy | 92 | 7 |
| id | movie_id | day | seats | price |
|---|---|---|---|---|
| 1 | 1 | Fri | 2 | 40 |
| 2 | 1 | Sat | 4 | 80 |
| 3 | 2 | Fri | 1 | 25 |
| 4 | 3 | Sat | 3 | 54 |
| 5 | 4 | Sun | 2 | 60 |
| 6 | 1 | Sun | 1 | 20 |
| 7 | 5 | Sat | 2 | 36 |
| 8 | 3 | Sun | 5 | 90 |
| id | title | genre | minutes | rating |
|---|---|---|---|---|
| 1 | Robot Summer | family | 95 | 8 |
| 2 | Dark Lake | horror | 110 | 6 |
| 3 | Space Pals | family | 88 | 7 |
| 4 | The Long Road | drama | 142 | 9 |
| 5 | Laugh Track | comedy | 101 | 5 |
| 6 | Snow Day | comedy | 92 | 7 |
| id | movie_id | day | seats | price |
|---|---|---|---|---|
| 1 | 1 | Fri | 2 | 40 |
| 2 | 1 | Sat | 4 | 80 |
| 3 | 2 | Fri | 1 | 25 |
| 4 | 3 | Sat | 3 | 54 |
| 5 | 4 | Sun | 2 | 60 |
| 6 | 1 | Sun | 1 | 20 |
| 7 | 5 | Sat | 2 | 36 |
| 8 | 3 | Sun | 5 | 90 |
SELECT title, -- 在这里写：括号里一个 COUNT(*) 的小查询，只数 movie_id 等于这部电影 id 的 FROM movies;
写好了先点「运行」看看结果，没问题再点「提交」。