SQL CTE example

Use a SQL common table expression (WITH) to organize a multi-step query.

The CTE calculates each employee's team average before the outer query selects people earning above that average.