Databases | SQL | Oracle | MS Access Answers

Get all the potential users. Fetch the user_ids who liked at least 2 videos published by "Disney" channel, and who did not subscribe to the channel (channel_id = 352).

Note:

• Consider reaction_type LIKE as liked.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of potential_user_id.

Expected Output Format

potential_user_idno_of_likes

sir plz explain the sql query

Get all the user_ids who liked at least 5 videos published by "Tedx" channel.

Note:

• Consider reaction_type LIKE as liked.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of active_user_id.

Expected Output Format

active_user_idno_of_likes

sir plz explain the sql query

Best time to upload a comedy video:

DunkFest channel is planning to upload a video in the "COMEDY" genre

Give the channel the best suitable hour of the day when users positively engage more with comedy videos.

Note:

• Consider positive engagement as LIKE for the videos in the "COMEDY" genre_type.
• Consider reaction_type LIKE as liked.
• Return the hour in the integer format

Expected Output Format

hour_of_engagementno_of_likes5

sir plz explain sql query

Get all the distinct user_ids who liked at least one video uploaded by Android Authority Channel (channel__id = 364) but didn't like the video uploaded by Tech savvy channel with video_id = 1005.

Note:

• Consider reaction_type LIKE as liked
• Sort the output in the ascending order of user_id.

Expected Output Format

user_id

sir plz explain sql query

Create a view based on the MyCustomers table that lists the customer last name, first name and email. Do not include the customer# in the view. Name the view Contact. View the contents of the view.

Describe the working procedure of 8255A with your own words.

Show the most recent five orders that were purchased from account numbers that have spent more than $70,000 with AdventureWorks.

Write separate queries using a join, a subquery, a CTE, and then an EXISTS to list all AdventureWorks customers who have not placed an order.

Write a trigger for the Product table to ensure the list price can never be raised more than 15 Percent in a single change. Modify the above trigger to execute its check code only if the ListPrice column is  updated (Use AdventureWorks Database).

Help in doing this : Create a function that takes as inputs a SalesOrderID, a Currency Code, and a date, and returns a table of all the SalesOrderDetail rows for that Sales Order including Quantity, ProductID, UnitPrice, and the unit price converted to the target currency based on the end of day rate for the date provided. Exchange rates can be found in the Sales.CurrencyRate table. ( Use AdventureWorks)