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 in MS SQL Server

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.