Question: Using the AdventureWorks 2 0 1 9 database, create SQL queries that answer the following questions ( 1 0 0 points, 1 0 points each
Using the AdventureWorks database, create SQL queries that answer the following questions points, points each:
How many customers AdventureWorks has?
Retrieve the top products with the highest list prices from the "Production.Product" table.
Retrieve the top most expensive products from the Product table.
Retrieve the order number, order date, and total due amount for orders placed by the customer with CustomerID
Calculate the total revenue for each product.
Retrieve the top bestselling products along with the total quantity sold for each product.
Retrieve the number of orders placed in each year.
Calculate the total sales amount for each year.
Calculate the total revenue for each sales territory.
Calculate the average sales amount per order for each month in the year
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
