On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - 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.