Aggregate correctly around NULLs — why aggregates ignore NULL, COUNT of all rows versus a column, SUM, the dangerous AVG, MIN and MAX, GROUP BY with NULLs, and percentage calculation pitfalls.
Loading content...