Answer to Question #176178 in Databases | SQL | Oracle | MS Access for ghyuar

Question #176178

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


1
Expert's answer
2021-04-03T18:40:38-0400

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;


Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

Assignment Expert
20.05.21, 14:38

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.



GAGANPREET SINGH DHILLON
20.05.21, 14:16

can you solve this question using subqueries , i'm getting error please correct this

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS