Answer to Question #284168 in Databases | SQL | Oracle | MS Access for Lovely

Question

18. 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 DISTINCT genre_id FROM video WHERE video.channel.id=364 AND video.video_id != 1005 AND video.reaction_type LIKE 'liked' ORDER BY user_id ASC;