Get to know tables
OVER()
6. OVER() - practice
Computations with OVER()
Aggregate functions with OVER()
OVER() and WHERE
Revision

## Instruction

Good job. Let's try one more exercise.

## Exercise

For each item in the purchase table, select its name (column item), price and the average price of all items.

### Stuck? Here's a hint!

Use

AVG(price) OVER()
in order to get the average price of all items.

Code editor

TableConsole