Databases | SQL | Oracle | MS Access Answers

7. Get all the videos that belong to "Action" genre (genre_id = 201) and have more than 1 lakh views.

Note:

• Sort the output in the ascending order of video_id.

Expected Output Format:

video_id

name

genre id

6. Get all the unique channels that published review videos.

Note:

You can consider the videos which contain "review" in name as review videos.

Sort the output in the ascending order of channel_name.

Expected Output Format:

channel_name

4. Get all distinct channels which published music videos before 2016.

Note:

• You can consider the videos which contain "music" in name as music videos.

• Sort the output in the ascending order of chanel_name.

Expected Output Format:

channel_name

3. Get all the music videos released before the year 2016.

Note:

• You can consider the videos which contain "music" in name as music videos.

. Get the year in the integer format

• Sort the output in the descending order of year, and then in the ascending order of name.

Expected Output Format:

name

no_of_views

year

1. Fetch the top 10 videos having more number of views.

Note:

Sort the output in the descending order of no_of_views, and then in the ascending order of name.

Expected Output Format:

name

no_of_views

11. Get all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

Note:

. Consider all the videos that have any of the technologies mentioned above in their name

• Sort the output in the ascending order of channel_id

Expected Output Format

channel_ld

6. Find the sum of durations of the videos published by each channel in hours.

Note:

• The output must contain the duration as number of hours.

.

Sort the output in the descending order of the no_of_hours

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

List of Entities :-

- Auction

- Item

- Bidding

- Administrator

- Buyer

- Payment

By considering these entities in your system, you must identify entity attributes and cardinality between provided entities. Note that you are not required to add any extra entity from your side. So, your Task is to;

• Draw Entity Relationship Diagram containing entities and assumed attributes.

• Mention cardinalities between these entities.

get the total number of distinct countries where the users are located.country of the user is present in the user table

Jst a query how to write please help me