Introduction
2. Table website
LEAD and LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE
Revision

Instruction

In this part, we're going to work with statistics of a few webpages that generate profit based on users' clicks on various advertisements. To do that, we'll only need two tables. Let's check them now.

Exercise

Select all the information from the website table.

Each website has an id, name, monthly budget and the date of opening (opened).

Console

Code editor

Result

TableConsole