How many times each user has engaged with the videos of "News for you" channel (id = 366).
user_id no_of_reactions......
SELECT vd.user_id,count(vd.reaction_type) as no_of_reactions
FROM quiz.video_content as vc,quiz.view_details as vd
where vd.user_id=336
order by no_of_reactions;
Comments
Leave a comment