Using ORDER BY (Q2)

Medium

Using the same table music_chart, write a SQL query to list all songs from the years 2020 and 2021, but order them first by year in descending order (latest year first) and then by song title in alphabetical order.

Example Output:

year_rank	year	artist	song_title
2	2021	The Dreamers	Awake in Dreams
5	2021	Rhythm Knights	Dance of the Dawn
8

Using ORDER BY (Q2)

Medium

Using the same table music_chart, write a SQL query to list all songs from the years 2020 and 2021, but order them first by year in descending order (latest year first) and then by song title in alphabetical order.

Example Output:

year_rank	year	artist	song_title
2	2021	The Dreamers	Awake in Dreams
5	2021	Rhythm Knights	Dance of the Dawn
8