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

Question #176176

How many times each user has engaged with the videos of "News for you" channel (id = 366).

Note:

  • Consider engagement as LIKE or DISLIKE for a video uploaded by News for you channel.
  • Ignore the users who did not engage with the channel at least once.
  • Sort the output in the descending order of no_of_reactions, and then in the ascending order of user_id.

Expected Output Format

user_id no_of_reactions......


1
Expert's answer
2021-04-03T00:08:30-0400
SELECT vd.user_id,count(vd.reaction_type) as no_of_reactions
FROM quiz.video_content as vc,quiz.view_details as vd
where vd.user_id=336
order by no_of_reactions;

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

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS