Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Simple OVER()
PARTITION BY
Ranking functions
Window Frames
Analytic Functions
PARTITION BY ORDER BY
Order of Evaluation
29. Ranking of Platforms
Finished!

Instruction

Our time on the practice field is nearly done! The last two questions deal with the order of evaluation.

Exercise

For each platform, show the following: the Platform name, the sum of subscription payments for that platform (column TotalPaymentAmount), and the platform's Rank based on that sum. The platform with the highest sum should get the rank of 1).

Stuck? Here's a hint!

As the window function you should use:

RANK() OVER(ORDER BY SUM(PaymentAmount) DESC)