Introduction
PARTITION BY
Ranking functions
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary
Instruction
Fine. Let's do three more ranking exercises.
Exercise
Rank single_rental 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.
