Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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.