Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Get to know tables
OVER()
Computations with OVER()
Aggregate functions with OVER()
11. Practice 2
OVER() and WHERE
Summary

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.