<invoke name="query_sql"> <parameter name="sql">SELECT 'Age' AS col, Age AS val, COUNT(*) AS n FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE TRY_CAST(Age AS DOUBLE) IS NULL GROUP BY Age UNION ALL SELECT 'Gender', Gender, COUNT(*) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE Gender IS NULL OR TRIM(Gender) = '' OR LOWER(TRIM(Gender)) IN ('na','n/a','nan','null','none','unknown') GROUP BY Gender UNION ALL SELECT 'Monthly_Income', Monthly_Income, COUNT(*) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE TRY_CAST(Monthly_Income AS DOUBLE) IS NULL GROUP BY Monthly_Income UNION ALL SELECT 'Would_Recommend', Would_Recommend, COUNT(*) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE Would_Recommend IS NULL OR TRIM(Would_Recommend) = '' OR LOWER(TRIM(Would_Recommend)) IN ('na','n/a','nan','null','none','unknown') GROUP BY Would_Recommend</parameter> <parameter name="purpose">Identify how missing values are encoded in text columns (step-1 showed 0 NULLs but step-0 showed non-zero missing)</parameter> </invoke> <parameter name="source">raw</parameter> </invoke> </invoke> </invoke> ``` Wait — correcting format. <invoke name="query_sql"> <parameter name="sql">SELECT 'Age' AS col, Age AS val, COUNT(*) AS n FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE TRY_CAST(Age AS DOUBLE) IS NULL GROUP BY Age UNION ALL SELECT 'Gender', Gender, COUNT(*) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE Gender IS NULL OR TRIM(Gender) = '' OR LOWER(TRIM(Gender)) IN ('na','n/a','nan','null','none','unknown') GROUP BY Gender UNION ALL SELECT 'Monthly_Income', Monthly_Income, COUNT(*) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE TRY_CAST(Monthly_Income AS DOUBLE) IS NULL GROUP BY Monthly_Income UNION ALL SELECT 'Would_Recommend', Would_Recommend, COUNT(*) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals WHERE Would_Recommend IS NULL OR TRIM(Would_Recommend) = '' OR LOWER(TRIM(Would_Recommend)) IN ('na','n/a','nan','null','none','unknown') GROUP BY Would_Recommend</parameter> <parameter name="purpose">Identify how missing values are encoded in text columns (step-1 showed 0 NULLs but step-0 showed non-zero missing)</parameter> <parameter name="source">raw</parameter> </invoke>