书架的顺序是：story 在前，science 其次，food 最后；同一类里按 title 字母顺序。选出 title 和 genre，按这个顺序排。
| id | title | author | genre | pages | year |
|---|---|---|---|---|---|
| 1 | The Night Garden | Mia Lane | story | 210 | 2015 |
| 2 | Stars for Kids | Tom Hart | science | 96 | 2020 |
| 3 | Lost at Sea | Mia Lane | story | 340 | 2011 |
| 4 | Easy Bread | Rosa Bell | food | 128 | 2019 |
| 5 | The Bug Book | Tom Hart | science | 64 | 2022 |
| 6 | Soup Days | Rosa Bell | food | 150 | 2008 |
| 7 | The Red Kite | Ann Cole | story | 180 | 2021 |
| 8 | Rocks and Rivers | Ann Cole | science | 220 | 2017 |
| id | book_id | reader | days |
|---|---|---|---|
| 1 | 1 | Leo | 14 |
| 2 | 2 | Nora | 7 |
| 3 | 1 | Sam | NULL |
| 4 | 4 | Leo | 21 |
| 5 | 5 | Nora | NULL |
| 6 | 3 | Ivy | 10 |
| 7 | 2 | Sam | 5 |
| 8 | 7 | Ivy | 12 |
| id | title | author | genre | pages | year |
|---|---|---|---|---|---|
| 1 | The Night Garden | Mia Lane | story | 210 | 2015 |
| 2 | Stars for Kids | Tom Hart | science | 96 | 2020 |
| 3 | Lost at Sea | Mia Lane | story | 340 | 2011 |
| 4 | Easy Bread | Rosa Bell | food | 128 | 2019 |
| 5 | The Bug Book | Tom Hart | science | 64 | 2022 |
| 6 | Soup Days | Rosa Bell | food | 150 | 2008 |
| 7 | The Red Kite | Ann Cole | story | 180 | 2021 |
| 8 | Rocks and Rivers | Ann Cole | science | 220 | 2017 |
| id | book_id | reader | days |
|---|---|---|---|
| 1 | 1 | Leo | 14 |
| 2 | 2 | Nora | 7 |
| 3 | 1 | Sam | NULL |
| 4 | 4 | Leo | 21 |
| 5 | 5 | Nora | NULL |
| 6 | 3 | Ivy | 10 |
| 7 | 2 | Sam | 5 |
| 8 | 7 | Ivy | 12 |
SELECT title, genre FROM books -- 在这里写：ORDER BY 一个 CASE（story 1、science 2、其他 3），再按 title ;
写好了先点「运行」看看结果，没问题再点「提交」。