Get to know the data
Get to know the OVER() clause
Computations with OVER()
Aggregate functions with OVER()
Using OVER() with WHERE
Summary
16. Exercise 2

Instruction

Great! Now, the more difficult exercise!

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).