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
The Final Quiz
13. Question 10
You’ve Completed the Windows Function Course!

Instruction

Excellent! We’re on Question 10 now. Just two more to go!

Exercise

For each treatment, show the following information: TreatmentDate, Name, Price, Category, Score, the Price of the best treatment from the same category (in terms of the Score), and the difference between the current treatment's Price and the best treatment's Price. Name these last two columns BestTreatment and Difference.