A named summary with meaning
You already know totals and counts. Turn them into a readable report: minimum and maximum, the gap between them and distinct buyers. Give each number a name describing exactly what it measures.
An expression computes a value; AS names it. MIN/MAX find extremes, and COUNT(DISTINCT column) counts distinct non-NULL values.
- A named summary with meaning
- An expression computes a value; AS names it. MIN/MAX find extremes, and COUNT(DISTINCT column) counts distinct non-NULL values.