Question
SQL #Display Category Name, Product Name, Customer Company Name and TotalPrice which is a calculated column (UnitPrice * Quantity * (1 Discount)). Use the Order
SQL
#Display Category Name, Product Name, Customer Company Name and TotalPrice which is a calculated column (UnitPrice * Quantity * (1 Discount)). Use the Order Details table to get the UnitPrice. Only return rows that have a category name of Produce, Seafood, or Beverages and have a TotalPrice greater than or equal to $200+99. Sort the result set by Category Name and then by Product Name and then by TotalPrice from highest to lowest. (hint: this query needs 5 tables)
# Using the same criteria from Query #6, display the number of line items (Order Details table) for each category and the average TotalPrice for each category.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started