Introduction
Ranking functions
Selecting n-th row
Revision

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!

Use the previous example to help you:

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

Console

Code editor

Result

TableConsole