Answer to Question #234429 in Databases | SQL | Oracle | MS Access for Suraj

Question

get all the music video released before the year 2016. you can consider the video which contains "music" as name as music video.sort th output in descending order of the year and ascending order of name.

Answer 1

SELECT * FROM music mc
WHERE mc.year <= 2016 AND mc.music_video LIKE '%music%' 
ORDER BY mc.year DESC, mc.music_video ASC