Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in PostgreSQL

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.