Answer to Question #211431 in Databases | SQL | Oracle | MS Access for Madhav

Question

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.

In subquries method

Answer 1

SELECT vi.user_id,count(vi.reaction_type)
FROM VIDEO vi WHERE vi.channel=336 
ORDER BY no_of_reactions DESC