Answer to Question #215994 in Databases | SQL | Oracle | MS Access for THOTA RAVI TEJA

Question

Get the number of videos released in each year.

Note:

• For this question, convert theyearin string datatype to INT datatype.
• Sort the output in the ascending order ofyear

Answer 1

SELECT COUNT(no_of_videos)
FROM Video;
GROUP BY year;
ORDER BY year;