Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Nested CTEs
Summary
14. Exercise 2

Instruction

Very good. Now for the second question!

Exercise

A city is performing well if their total number of items sold is above the average for their region. For each city, show its Name and its Label – either N'Above average' or N'Below average' – depending on how well the city performs.