SQL
SQL pivot tables: CASE WHEN, COUNT and the traps around NULL
A pivot can look correct while losing orders. I show how to count categories, distinguish zero from missing data and reconcile the columns with the source.
Tag
null values
KajoData articles about null values. Practical knowledge about data analysis, tools and careers.
Articles: 1