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

Question

4. Get all distinct channels which published music videos before 2016.

Note:

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

• Sort the output in the ascending order of chanel_name.

Expected Output Format:

channel_name

Answer 1

SELECT ​DISTINCT music_vid
FROM ​ video WHERE year < "2016" ORDER BY chanel_name ASC