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

Introduction
3. Table statistics
LEAD and LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE
Summary

Instruction

Fine! Now, the other table.

Exercise

Select all the information from the statistics table.

In this table, you can find the statistics from May 2016. Each generated statistics row corresponds to a certain website_id and a particular day. Column users shows how many unique people visited the website that day. Column impressions indicates how many times an advertisement was shown to a user. clicks means the number of clicks on an advertisement. Column revenue is the total profit generated by those clicks on that day.