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.