Answer to Question #171235 in Databases | SQL | Oracle | MS Access for kaashu

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.

Answer 1

SELECT distinct user_id
FROM quiz.view_details
where view_details.video_id!=1005 and view_details.user_id=364;