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

Question

14. Get the active users of the platform. Consider the users who liked at least fifty videos are considered active users.

Note:

. Consider reaction_type LIKE as liked.

• Sort the output in the ascending order of user_id.

Expected Output Format

active_user_id

no_of_likes

Answer 1

SELECT ​vd.user_id as activeUser
FROM ​quiz.view_details as vd, quiz.reaction as r
where ​vd.reaction_type="like" and count(r.id=r.vid)>50
group ​by vd.user_id