Answer to Question #210039 in Databases | SQL | Oracle | MS Access for Madhav

Question

Get top 5 genres in the platform with most positive users activity i.e the genres with videos having more number of likes

Answer 1

SELECT vd.user_id as activeUser
FROM quiz.view_details as vd, quiz.reaction as r
where vd.reaction_type="like" and count(r.id=r.vid)>50
group by vd.user_id asc;