Get the active users of the platform. Consider the users who liked at least fifty videos are considered active users.
active_user_id no_of_likes
... ...
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 asc;
Comments
Leave a comment