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

Question

1. Fetch the top 10 videos having more number of views.

Note:

Sort the output in the descending order of no_of_views, and then in the ascending order of name.

Expected Output Format:

name

no_of_views

Answer 1

select vc.name, vc.no_of_views, ch.name
from video_content as vc,channel as ch
order by vc.no_of_views;