周末过完了，电影院想看看票房。把 movies 和 tickets 连起来，算出每部电影卖票的总钱数（price 加起来），按总钱数从多到少排。没卖出票的电影不用列。
| 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 movies.title, SUM(tickets.price) FROM movies JOIN tickets ON tickets.movie_id = movies.id -- 在这里写：按电影名 GROUP BY，再按 SUM(tickets.price) 从大到小 ORDER BY ;
写好了先点「运行」看看结果，没问题再点「提交」。