Answer to Question #176177 in Databases | SQL | Oracle | MS Access for ghyuar

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);