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

Instruction

Good job! We're getting close to the end – we’ve made it to Question 9.

Exercise

For each treatment, show its Name, Score, Price, Category, the average price in its category (as AvgPrice), the average score in its category (as AvgScore) and that treatment's rank in the category (based on its Score). The treatment with the highest Score should get Rank 1. Name this column Ranking. Multiple treatments can have the same rank, but don't allow gaps in numbering.