PROCEDURE 1: Define the VIEW named ProductInfo that returns three columns: Product ID, Order Quantity, and Average Unit Price for each product type where the product sold more than 20 units for 2014. Then, write a SELECT statement that returns all of the columns in the view, sorted by Average Price in descending order. [You should write SQL query,

Question

student submitted image, transcription available below

PROCEDURE 1: Define the VIEW named ProductInfo that returns three columns: Product ID, Order Quantity, and Average Unit Price for each product type where the product sold more than 20 units for 2014. Then, write a SELECT statement that returns all of the columns in the view, sorted by Average Price in descending order. [You should write SQL query, do not use SQL design tool]
PROCEDURE 2: Write a script that declares and a variable that is equal the total sales price. If total sales price is greater than 100.000.000, it should select records from SalesOrderDetail table. If the total sales price is less than 100.000.000, it should select records from the SalesOrderHeader table

ASSIGNMENT (Upload the solution to the CATs by your ID) Use the E-R diagram in below for this assignment. (Adventureworks2019)

Accepted Answer

Expert Answer to - PROCEDURE 1: Define the VIEW named ProductInfo that returns three columns: Product ID, Order Quantit

Answer

Solution for - PROCEDURE 1: Define the VIEW named ProductInfo that returns three columns: Product ID, Order Quantit

Answer

This an additional answer to - PROCEDURE 1: Define the VIEW named ProductInfo that returns three columns: Product ID, Order Quantit

(Solved): PROCEDURE 1: Define the VIEW named ProductInfo that returns three columns: Product ID, Order Quantit ...

View Expert Answer

Expert Answer

Buy This Answer $5

Place Order

We Provide Services Across The Globe