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

Question #176183

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

... ...


1
Expert's answer
2021-03-29T05:08:05-0400
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;

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