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

Question

Best time to upload a comedy video:

DunkFest channel is planning to upload a video in the "COMEDY" genre

Give the channel the best suitable hour of the day when users positively engage more with comedy videos.

Note:

• Consider positive engagement as LIKE for the videos in the "COMEDY" genre_type.
• Consider reaction_type LIKE as liked.
• Return the hour in the integer format

Expected Output Format

hour_of_engagement no_of_likes

5 ...

Answer 1

select count(vd.reaction_type) as no_of_likes
from  quiz.view_details as vd, quiz.video
where  vd.reaction_type='LIKE' and genre_type='comedy'