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

Question

Get all the videos that have more than the average number of views,

Note:

• Sort the output in the ascending order of name.

Expected Output Format

name

no_of_views

Answer 1

SELECT vc.name,vc.no_of_views
FROM quiz.video_content as vc
where vc.no_of_views>(vc.no_of_views);