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

Instruction

You’re on a roll! Let's solve the final problem: Question 11.

Exercise

Find out which doctor is the best for each treatment. For each treatment select the treatment Name and the first and last name of the doctor who most most frequently receives a high score for that treatment. (A high score is higher than or equal to the average score for this treatment.) Make sure that the highest-scoring doctor gets Rank = 1.