Answer to Question #284121 in Databases | SQL | Oracle | MS Access for Lovely

Question

3. Get all the music videos released before the year 2016.

Note:

• You can consider the videos which contain "music" in name as music videos.

. Get the year in the integer format

• Sort the output in the descending order of year, and then in the ascending order of name.

Expected Output Format:

name

no_of_views

year

Answer 1

SELECT ​DISTINCT music_vid, year
FROM ​ video WHERE year < "2016" ORDER BY year DESC, name ASC