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 2019 database, create SQL queries that answer the following questions (100 points, 10 points each):
1. How many customers AdventureWorks has?
2. Retrieve the top 5 products with the highest list prices from the "Production.Product" table.
3. Retrieve the top 5 most expensive products from the Product table.
4. Retrieve the order number, order date, and total due amount for orders placed by the customer with CustomerID 30052.
5. Calculate the total revenue for each product.
6. Retrieve the top 3 best-selling products along with the total quantity sold for each product.
7. Retrieve the number of orders placed in each year.
8. Calculate the total sales amount for each year.
9. Calculate the total revenue for each sales territory.
10. Calculate the average sales amount per order for each month in the year 2014.

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 Databases Questions!