Answer to Question #270447 in Databases | SQL | Oracle | MS Access for Akhil

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:

yearno_of_videos......

Answer 1

select Year, Date yearno_of_videos  FROM videos 
WHERE Date between '2010/01/01' and '2016/12/31' ORDER BY Year ASC