Save up to $499! Grab all Python courses for$49 or all online courses we’ve ever launched for only \$169. Only Feb 11-16. Happy Valentine's!
Introduction
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.