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

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.

Console

Code editor

Result

TableConsole