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.
hour_of_engagement no_of_likes
5 ...
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'
Comments
Leave a comment