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 in PostgreSQL

Introduction
Simple OVER()
PARTITION BY
Ranking functions
Window frame
21. Window frame – Exercise 3
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary

Instruction

Amazing! And the second exercise now.

Exercise

For each subscription, show the following columns: id, length, platform, payment_date, payment_amount and the future cashflows calculated as the total money from all subscriptions starting from the beginning of the payment_date of the current row (i.e. include any other payments on the very same date) until the very end.

Stuck? Here's a hint!

This time, instead of ROWS, we need RANGE: RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING.