Answer to Question #284158 in Databases | SQL | Oracle | MS Access for Lovely

Question

15. 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