Name the steps, add some logic
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.
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.