Using ORDER BY (Q2)

SQL+1Medium

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

Using ORDER BY (Q2)

SQL+1Medium

Example Output:

year_rank	year	artist	song_title
2	2021	The Dreamers	Awake in Dreams
5	2021	Rhythm Knights