Homework Answers

A descending order means values arranged from largest to smallest. But in your case, you're going to have to sort these integers in ascending order, which means from smallest to largest.




Instructions:

Input three integers.
Print the integers in ascending order using your knowledge on conditional statements.

Input

A line containing three integers separated by a space.

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