Real reports chain several steps: total the points, compare with the average, label each player. A CTE (common table expression, written with WITH) names each step, and CASE adds if-then logic to any column.