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

Question

9. Find the number of videos published between the years 2010 & 2016.

Note:

• Sort the output in the ascending order of the year

Keep the year in the integer format

Expected Output Format:

year

no_of_videos

Answer 1

select ​vc.no
from ​video_content as vc
order ​by vc.name