Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. Table website
LEAD and LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE
Summary

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).