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

Question

6. Get the number of videos published by each channel.

Note:

• If a channel did not upload any video, keep the no_of_videos as 0.

• Sort the output in the ascending order of channel_name.

Expected Output Format

channel_name

no of videos

Answer 1

SELECT videos, COUNT(*) 
FROM channels 
GROUP BY channel_id
ORDER BY channel_name ASC;