Answer to Question #330146 in Databases | SQL | Oracle | MS Access for Bylapati suresh kumar

Question #330146

Categorise the performance of all the videos released by the “Motivation grid” Channel (id = 350).

Performance of a video is measured based on the number of views of the video.

Categorization

no_of_viewscategory<= 10000 poor

10000 < views <= 100000

and

average> 100000 good

Note

Sort the output in the ascending order of

published_datetimeExpected Output Format

name , no_of_views , category




SELECT

 name,

 sum(no_of_views) AS no_of_views,

 CASE

  WHEN sum(no_of_views) <= 10000 THEN "poor"

  WHEN sum(no_of_views) < 10000

  AND sum(no_of_views) <= 100000 THEN "average"

  ELSE "good"

 END AS category

FROM

 video

WHERE

 channel_id = 350

GROUP BY

 name

ORDER BY

 published_datetime DESC;



please help


0
Service report
It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS