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

Question

10. Get all the distinct user_ids who liked at least one video uploaded by Android Authority Channel (channel_id = 364) but didn't like the video uploaded by Tech savvy channel with video_id=1005.

Note:

. Consider reaction_type LIKE as liked

• Sort the output in the ascending order of user_id

Expected Output Format

user Is

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;