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

Recursive Queries in MS SQL Server

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.