LEAD and LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE
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).
