Answer to Question #185024 in Databases | SQL | Oracle | MS Access for bhadra

Question #185024

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_idno_of_likes

sir plz explain the sql query


1
Expert's answer
2021-04-25T07:16:12-0400
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

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