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