Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
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.