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

Question

6. Get all the unique channels that published review videos.

Note:

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

Sort the output in the ascending order of channel_name.

Expected Output Format:

channel_name

Answer 1

SELECT vd.user_id
FROM quiz.video_content as vc,quiz.view_details as vd
where vd.user_id=336
order by user_name;