Question

Get the top 3 genre_ids that are liked by the users in India in the year 2018.

Note:

• Consider the name of the country as "INDIA"
• Consider reaction_type LIKE as liked. If a video belongs to 3 genres, then the like is counted in all the 3 genres.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of the genre_id.

Expected Output Format

genre_id no_of_likes

... ...

Answer 1

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: