LEAD() and LAG()
FIRST_VALUE(), LAST_VALUE()
Instruction
Great! The last exercise ahead of you.
Exercise
For each row where WebsiteId = 3, show the Day, the number of clicks on that day, and the Ratio (expressed as percentage) of the number of clicks on that day to the greatest number of clicks on any day. Round the percentage to an integer value.
Stuck? Here's a hint!
To avoid integer division, use CAST(Clicks AS NUMERIC). Also, use ROUND(Column, Precision) to round the percentage.
