Question: Extract data from the PVFC database corresponding to the following questions. For each question, provide the SQL query and a screenshot of the result set

Extract data from the PVFC database corresponding to the following questions. For each question, provide the SQL query and a screenshot of the result set output from the SQL Server Management Studio.

Retrieve a list of the orders greater than $1,000 placed after 9/1/2017 and before 3/11/2018, sorted in descending order of the total dollar amount of the order. Also provide the total quantity of items included in the order, as well as the average price of all items included in the order. The query should output the customer ID, customer name, order ID, the total dollar amount of the order, total quantity of items included, and average price of items included.

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!