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

Question

13. 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

Answer 1

SELECT CAST(REPLACE(Hours,':','') AS INT) As 
hour_of_engagementno_of_likes5
FROM COMEDY
WHERE Engagement = 'LIKE'
GROUP BY Hours 
HAVING COUNT(Hours)>1
ORDER BY COUNT(Hours)
DESC LIMIT 1