Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
Nested CTEs
11. Exercise 4
Summary

## Instruction

Great! Now let's try a really challenging exercise.

## Exercise

We define a 'Good' sales rep as one whose total amount earned is above the average total amount earned in their city.

We want to compare the average number of items sold between two groups of sales reps: the 'Good' reps and 'Bad' reps.

In the result, we want to get a table like this, but with appropriate numbers:

Label Average
Good 3.12