It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
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;