Introduction
LEAD and LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE
23. Practice 2
Revision

Instruction

Perfect! Let's move on.

Exercise

Take the statistics for website_id = 1. For each row, show the day, the number of clicks on that day and the median of clicks in May 2016 (calculated as the 16th value of all 31 values in the column clicks when sorted by the number of clicks).

Stuck? Here's a hint!

Define the window frame as ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING.

Console

Code editor

Result

TableConsole