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

Question

8. Get all the Indian users details whose age is below 30 years and liked the video (video_id=1011) in the year 2020.

Note:

Consider the name of the country as "INDIA"

. Consider reaction_type LIKE as liked.

Sort the output in the ascending order of name.

Expected Output Format:

name

gender

age

country

Answer 1

SELECT DISTINCT user_id FROM video WHERE video.channel.id=364 AND video.video_id != 1005 AND video.reaction_type LIKE 'liked' ORDER BY user_id ASC;