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.
user_id
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;
Comments
Dear GAGANPREET SINGH DHILLON, if you have serious assignment that requires large amount of work and hence cannot be done for free you can submit it as assignment and our experts will surely assist you.
can you solve this question using subqueries , i'm getting error please correct this
Leave a comment