Fill in the order form to get the price

Subject

Category

Deadline

Timezone:

Title *

Task *

{"ops":[{"insert":"Categorise the performance of all the videos released by the \u201cMotivation grid\u201d Channel (id = 350).\nPerformance of a video is measured based on the number of views of the video.\nCategorization"},{"attributes":{"header":4},"insert":"\n"},{"insert":"no_of_viewscategory<= 10000   poor\n10000 < views <= 100000\n and \naverage> 100000 good\nNote"},{"attributes":{"header":4},"insert":"\n"},{"insert":"Sort the output in the ascending order of\npublished_datetimeExpected Output Format"},{"attributes":{"header":4},"insert":"\n"},{"insert":"name  , no_of_views  , category\n\n\n\nSELECT\n\u00a0name,\n\u00a0sum(no_of_views) AS no_of_views,\n\u00a0CASE\n\u00a0\u00a0WHEN sum(no_of_views) <= 10000 THEN \"poor\"\n\u00a0\u00a0WHEN sum(no_of_views) < 10000\n\u00a0\u00a0AND sum(no_of_views) <= 100000 THEN \"average\"\n\u00a0\u00a0ELSE \"good\"\n\u00a0END AS category\nFROM\n\u00a0video\nWHERE\n\u00a0channel_id = 350\nGROUP BY\n\u00a0name\nORDER BY\n\u00a0published_datetime DESC;\n\n\nplease help\n"}]}

I need basic explanations

Special Requirements

Upload files (if required)

Drop files here to upload

Add files...

Account info

Already have an account?

Name *

E-mail *

Password *

The password must be at least 6 characters.

I agree with terms & conditions