Question

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_id

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;