SUM(CASE WHEN customer_id IS NULL THEN 1 ELSE 0 END) AS customer_id_nulls, SUM(CASE WHEN customer_unique_id IS NULL THEN 1 ELSE 0 END) AS customer_unique_id_nulls, SUM(CASE WHEN ...
SUM(CASE WHEN ReportDate IS NULL THEN 1 ELSE 0 END) AS null_reportdate_count, SUM(CASE WHEN CID IS NULL THEN 1 ELSE 0 END) AS null_cid_count, SUM(CASE WHEN RegulationID IS NULL THEN 1 ELSE 0 END) AS ...