Using LIMIT (Q2)

Medium

Using the same music_chart table, write a SQL query to find these 5 songs from the year 2020 and 2021. You need to sort them first by their artist's name in descending order then by their song_title in ascending order, and finally by their release year (oldest first).

Example Output:

year_rank	year	artist	song_title
1	2020	Vibrant Keys	Melancholic Keys
3	2020	Urban Echo	City Lights

Using LIMIT (Q2)

Medium

Using the same music_chart table, write a SQL query to find these 5 songs from the year 2020 and 2021. You need to sort them first by their artist's name in descending order then by their song_title in ascending order, and finally by their release year (oldest first).

Example Output:

year_rank	year	artist	song_title
1	2020	Vibrant Keys	Melancholic Keys
3	2020	Urban Echo	City Lights