Explore AdventureWorks Database. Create SQL queries to answer the questions below

Grouping

• Write a query to determine the number of customers in the Sales.Customer table.
• Write a query that lists the total number of products ordered. Use the OrderQty column of the Sales.SalesOrderDetail table and the SUM function.
• Write a query to determine the price of the most expensive product ordered. Use the UnitPrice column of the Sales.SalesOrderDetail tabl
• Write a query to determine the average freight amount in the Sales.SalesOrderHeader table.
• Write a query using the Production.Product table that displays the minimum, maximum, and average ListPrice.

Answer rating: 100% (QA)

To explore the AdventureWorks database and answer your groupingrelated questions you can us... View the full answer