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
Ranking functions
Selecting n-th row
Summary

Instruction

OK, it's time for practice.

Exercise

For each game, show name, genre, date of update and its rank. The rank should be created with RANK() and take into account the date of update.

Stuck? Here's a hint!

Here's the example from the previous exercise – use it to write the correct answer:

SELECT
  name,
  platform,
  editor_rating,
  RANK() OVER(ORDER BY editor_rating)
FROM game;