Introduction
PARTITION BY
Ranking functions
Window frame
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.
