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

Instruction

Fine. Let's do three more ranking exercises.

Exercise

Rank single_rentals in accordance with the price paid for them. For each single_rental, show the movie title, rental_period, payment_amount and the rank. Multiple single_rentals can share the same rank, the highest amount should have rank = 1 and gaps in numbering are allowed, too.

Stuck? Here's a hint!

Join two tables: movie and single_rental.

Console

Code editor

Result

TableConsole