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
1. Introduction
Selecting n-th row
Summary

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.