Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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
Summary

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.