影院要印一张片单。选出所有电影的 title、genre、minutes,先按 genre 从 A 到 Z 排;同一个类型的,再按 minutes 从长到短排。
| 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 |
-- 在这里写:ORDER BY 后面写两列,第二列从大到小 SELECT title, genre, minutes FROM movies;
写好了先点「运行」看看结果,没问题再点「提交」。