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

Question

6. Find the sum of durations of the videos published by each channel in hours.

Note:

• The output must contain the duration as number of hours.

.

Sort the output in the descending order of the no_of_hours

Answer 1

SELECT channelid, duration_in_secs/(60*60) as no_of_hours FROM quiz.video_content;

output: