Databases | SQL | Oracle | MS Access Answers

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

Get all the esport videos that crossed one lakh views and were released between 2018 and 2020.

Note:

• Consider the videos that have "esport" in theirname as gaming videos.
• Sort the output in the descending order ofno_of_viewsandpublished_datetime

Expected Output Format

name published_datetime no_of_views

this format write code please help............!!!!!!!

This is the code for Getting all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

SELECT

DISTINCT channel_id

FROM

video

WHERE

video_id >= 1

AND name LIKE '%AI/ML%'

OR name LIKE '%Robotics%'

AND strftime('%Y', published_datetime) BETWEEN "2018"

AND "2021"

GROUP BY

channel_id

ORDER BY

channel_id ASC;

How can I Get all the channel_ids that uploaded at least 20 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.

Example: If a channel publishes 5 videos in AI/ML, 10 videos in Cyber Security and 5 videos in Data Science, consider the channel

select video_content.channelid

FROM quiz.video_content inner join user_details u on quiz.video_id=u.user_id

WHERE count(u.user_id) >= 20 AND name like '%DIY%' OR name LIKE '%Robotics%'

"2018" AND "2021" GROUP BY video_content.channelid

ORDER BY video_content.channelid ASC;

This code is not executed please help

Get videos from TEDx channel (id=353) with more than 50 thousand views.

Note:

Sort the output in the descending order ofno_of_viewsand in the ascending order of videoname

Expected Output Format

video_id , name , duration_in_secs , no_of_views

Create a database for Car dealership.

For Marvel channel (id = 351), get the number of subscribers added in each month in the year 2020.

Note:

You can find the subscribed date of a user for a channel in thechannel_usertable.

For this question, convert themonth_of_yearin string datatype to INT datatype.

Sort the output in the ascending order of the month.

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.

Get the number of videos uploaded by each channel.