Get the top 3 genre_ids that are liked by the users in India in the year 2018.
genre_id no_of_likes
... ...
SELECT vd.user_id,count(reaction_type) as no_of_likes
from quiz.view_details as vd, quiz.user_details as ud
where vd.reaction_type="like" and ud.address='india'
order by vd.reaction_type asc,vd.user_id asc
Output:
Comments
Leave a comment