Ordering
List book titles, author name, author birth date, year of publication, in order
of birth date ascending, publication date descending.
select b.title, a.name, a.birth_date, b.year
from book b left join author a using (author_id)
order by a.birth_date asc, b.year desc
- b.year asc: Order by book year, ascending (which is the default).
- a.birth_date desc: In case of a tie for book year, order by author's birth_date, descending.
| title |
name |
birth_date |
year |
| Slaughterhouse Five | Kurt Vonnegut Jr. | 1922-11-11 | 1969 |
| Cat's Cradle | Kurt Vonnegut Jr. | 1922-11-11 | 1963 |
| Mother Night | Kurt Vonnegut Jr. | 1922-11-11 | 1962 |
| A Confederacy of Dunces | John Kennedy Toole | 1937-12-17 | 1980 |
| The Testaments | Margaret Atwood | 1939-09-18 | 2019 |
| A Handmaid's Tale | Margaret Atwood | 1939-09-18 | 1985 |
| Head Over Heels | Hannah Orenstein | 1993-04-21 | 2020 |
| Love at First Like | Hannah Orenstein | 1993-04-21 | 2019 |
| Playing With Matches | Hannah Orenstein | 1993-04-21 | 2018 |
| Beowulf | NULL | NULL | NULL |
| Diary of an Oxygen Thief | NULL | NULL | 2006 |
| A Woman in Berlin | NULL | NULL | 1959 |
|