Using ORDER BY (Q1)

Easy

You have a table music_chart with columns year_rank, year, artist, and song_title.

Write a SQL query to list all songs from the year 2021, ordered by their rank in ascending order (from the highest-ranked song to the lowest). Only display the artist name and the song title.

Example Output:

artist	song_title
Lunar Echoes	Moonlight Drive
The Dreamers	Awake in Dreams
Harmonic Waves	Ocean Tides
Melody Rays	Sunset Serenade

Using ORDER BY (Q1)

SQL+1

Easy

You have a table music_chart with columns year_rank, year, artist, and song_title.

Write a SQL query to list all songs from the year 2021, ordered by their rank in ascending order (from the highest-ranked song to the lowest). Only display the artist name and the song title.

Example Output:

artist	song_title
Lunar Echoes	Moonlight Drive
The Dreamers	Awake in Dreams
Harmonic Waves	Ocean Tides
Melody Rays	Sunset Serenade

Modules

Using ORDER BY (Q1)

Example Output:

Using ORDER BY (Q1)

Example Output: