Introduction
LEAD() and LAG()
FIRST_VALUE(), LAST_VALUE()
22. Practice 2
Summary

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.