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

Question

5. For all the videos, represent the number of views in multiples of thousands.

For example, if the number of views of a video is 17,200, it is represented as 17.2 in the output.

Note:

• Sort the output in the descending order of no_of_views_in_thousands, and then in the alphabetical order of name

Expected Output Format

video_id

name

no_of_views_in_thousands

Answer 1

The required query with the expected result:

SELECT * FROM mydb.channel_traffic where no_of_views>4000 ORDER BY no_of_views,name desc;