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

Question #176188

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

... ...


1
Expert's answer
2021-04-01T03:57:38-0400
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:

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