Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions

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.