Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Get to know the data
Get to know the OVER() clause
Computations with OVER()
Aggregate functions with OVER()
Using OVER() with WHERE
16. Exercise 2


Great! Now, the more difficult exercise!


For each purchase, show its:

  • Id,
  • the department Name,
  • the Item,
  • the Price,
  • the minimum price for all the rows in the query result (as MinPrice),
  • the difference between the item's Price and the minimum price (as Difference).