Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
LEAD and LAG
FIRST_VALUE, LAST_VALUE, NTH_VALUE
23. Practice 2
Summary

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