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

Question

Get all the user_ids who liked at least 5 videos published by "Tedx" channel.

Note:

• Consider reaction_type LIKE as liked.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of active_user_id.

Expected Output Format

active_user_id no_of_likes

... ...

Answer 1

SELECT 
e.ID,
e.Name,
l.UserID
FROM Entries e LEFT JOIN Likes l ON l.EntryID = e.ID
WHERE l.UserID = 5
ORDER BY e.Name