On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
1. Introduction
Selecting n-th row


Welcome! In this part, we'll teach you how to use window functions for something very useful – creating rankings. Which x is the best? Which x is in 3rd place? Which is the worst? These are the questions we're going to answer in this part.

Today, we're going to deal with a development studio that produces games for mobile platforms. Let's take a look at it.


Select all the information from table game.

Each game has an id and a name and is runnable on a specific platform. It is characterized by a specific genre, has an editor_rating and size in MB. The column released specifies when the game was released, whereas updated – when the game was last updated.