Question

Question 10
Which query will return song_title, artist_name, and album_title in alphabetical order by song_title?



4123
SELECT song_title, artist_name, album_title
FROM music_db.songs
ORDER BY song_title;




1234
SELECT song_title, artist_name, album_title
FROM music_db.songs
ORDER BY album_title;




1234
SELECT song_title, artist_name, album_title
FROM music_db.songs
ORDER BY artist_name DESC;




1234

Answer 1

The first query:

SELECT song_title, artist_name, album_title
FROM music_db.songs
ORDER BY song_title;

ORDER BY song_title sorts alphabetically (ascending) by song_title by default.