Introduction
2. Table customer
Simple OVER()
PARTITION BY
Ranking functions
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary

Instruction

As usual, we'll introduce the tables first. In this part, we're going to work with an on-line movie store which boasts the biggest database in our whole course – it contains as many as 6 tables. We'll analyze the tables in a second, but first, you can take a look at the ER diagram of this database created with our on-line tool Vertabelo. We present the diagram so that you can get the big picture first.

Vertabelo_Diagram

Exercise

Select all the information from the customer table.

Whoever wants to buy anything in our store needs to register as a customer. Each customer in our system has an id, first_name and last_name, join_date and the country.

Console

Code editor

Result

TableConsole