Introduction
2. Table store
Quick refresher
PARTITION BY ORDER BY with ranking
PARTITION BY ORDER BY with window frames
PARTITION BY ORDER BY with analytical functions
Revision

Instruction

Ok, first things first, as always. Today, we're going to work with a retail store. Let's get to know the tables.

Exercise

Select all the information from the store table.

Each store has its own id, country and city. There is only one store per city in our table to make things a bit easier. Apart from that, you can see when the store was opened and what rating it has (1-5), based on customers' opinions.

Console

Code editor

Result

TableConsole