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