Introduction
1. Introduction
Selecting n-th row
Revision

Instruction

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.

Exercise

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.

Console

Code editor

Result

TableConsole