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.