Get to know tables
OVER()
Computations with OVER()
Aggregate functions with OVER()
11. Practice 2
OVER() and WHERE
Revision

Instruction

Okay! Another one coming. This time, we'll have two window functions at once.

Exercise

For each purchase from any department, show its id, item, price, average price and the sum of all prices in that table.

Stuck? Here's a hint!

Simply separate both window functions with a comma, just as you separate columns.

Console

Code editor

Result

TableConsole