Question: 7. (10 Points) Use Delete statement to remove products that have not been ordered by any customers. Hint: A product that is not in the

7. (10 Points) Use Delete statement to remove products that have not been ordered by any customers. Hint: A product that is not in the table of order_details means the product has not been ordered, find (without duplicate) of those products.

8. (10 Points) Use Update and Case Statements to increase the retail price (under column RetailPrice) of products that are from CategoryID 1 and 2 by 10% and the rest of the products by 5%.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

You need to write your SQL query statements for each question and put them all in a single.SQL (or ,bxt file) and upload them to the assigned folder on D2L. Here is the ERD diagram of the datacode....

1: (10 Points) Use the customers table, and write a query statement to show CustFirstName, CustLastName, and CustCity columns. 2: (10 Points) Use the employees table, and write a query statement to...

need help please You need to write your SQL query statements for each question and put them all in a single. SQL (or .txt file) and upload them to the assigned folder on D2L. Here is the ERD diagram...

1: (10 Points] Use the customers table, and write a query statement to showr records from the CustFirstName, CustLastName, and CustCity columns. 2: [10 Points} Use the employees table, and write a...

6. (10 Points) Use subquery and show details of the customers that have not placed any orders. If a customer (i.e, its CustomerID) is not in the table of orders, that means the customer has not...

1. (10 Points) Use the customers table, and write a query statement to show CustFirstiame, Custlasthame. and Custcity columns. 2: (10 Points) Use the employees table, and write a query statement to...

Write your SQL query statements for each question. 1: Use the customers table, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns. 2: Use the...

1 : ( 1 0 Points ) Use the customers' table, and write a query statement to show CustomerName, state, and country columns. 2 : ( 1 0 Points ) Use the employees table, and write a query statement to...

6. Use subquery and show details of the customers that have not placed any orders. If a customer (i.e, its CustomerID) is not in the table of orders, that means the customer has not placed any...

Use a four-period moving average to forecast attendance at baseball games. Historical records show the following. 5,343, 7,809, 6,516, 5,782, 5,987, 6,520, 6,284, 5,582, 6,709, 7,340 Time Period...

Compute the runway distance a jet plane must travel as it accelerates at 7.00 m/s^2 (meters per second squared) from rest to take off speed of 80.0 m/s. Explain how you got your answer and the steps...

4 An example has been completed for you.Write a list of words and phrases that present the Lagina brothers in a positive way.

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...