Introduction
Simple OVER()
PARTITION BY
Ranking functions
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
30. Ranking of platforms
Summary

Instruction

Fine. The last two questions deal with the order of evaluation.

Exercise

For each platform, show the following columns: platform, sum of subscription payments for that platform and its rank based on that sum (the platform with the highest sum should get the rank of 1).

Stuck? Here's a hint!

Use RANK() OVER(ORDER BY SUM(payment_amount) DESC) as the window function.

Console

Code editor

Result

TableConsole