Home / Expert Answers / Computer Science / procedure-1-define-the-view-named-productinfo-that-returns-three-columns-product-id-order-quantit-pa528

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



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)


We have an Answer from Expert

View Expert Answer

Expert Answer





We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe