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
6. Practice time!
Computations with OVER()
Aggregate functions with OVER()
Using OVER() with WHERE
Summary

## Instruction

Good job! Let's try another exercise with OVER().

## Exercise

For each item in the Purchase table, select its name (in the Item column) and its Price. Also show the average price of all items (as AvgPrice).

### Stuck? Here's a hint!

Use:

AVG(Price) OVER()

to get the average price of all items. Don't forget about the alias.