Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in PostgreSQL

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