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
6. Question 3
You’ve Completed the Windows Function Course!

Instruction

Good answer! Question 3 is waiting.

Exercise

For each treatment, show its Name, the first and last name of the doctor, the Score given to that treatment, and the rank of the treatment in its category based on its Score (name the column Rank). The most successful treatment should get Rank = 1. Allow multiple treatments to have the same rank. Gaps in numbering are okay.