Answer to Question #180331 in Databases | SQL | Oracle | MS Access for deva

Question

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 theno_of_hours

Answer 1

select ch.channel_name,sum(vi.view_hour)
from channel as ch, view as vi
where ch.id=vi.id