<invoke name="query_sql"> <parameter name="sql">WITH t AS (SELECT * FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals) SELECT 'User_ID' AS col, COUNT(*) AS total, SUM(CASE WHEN User_ID IS NULL OR TRIM(User_ID)='' THEN 1 ELSE 0 END) AS missing FROM t UNION ALL SELECT 'Age', COUNT(*), SUM(CASE WHEN Age IS NULL OR TRIM(Age)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Gender', COUNT(*), SUM(CASE WHEN Gender IS NULL OR TRIM(Gender)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Country', COUNT(*), SUM(CASE WHEN Country IS NULL OR TRIM(Country)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'User_Type', COUNT(*), SUM(CASE WHEN User_Type IS NULL OR TRIM(User_Type)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Education_Level', COUNT(*), SUM(CASE WHEN Education_Level IS NULL OR TRIM(Education_Level)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Profession', COUNT(*), SUM(CASE WHEN Profession IS NULL OR TRIM(Profession)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Monthly_Income', COUNT(*), SUM(CASE WHEN Monthly_Income IS NULL OR TRIM(Monthly_Income)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'AI_Tool', COUNT(*), SUM(CASE WHEN AI_Tool IS NULL OR TRIM(AI_Tool)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'AI_Purpose', COUNT(*), SUM(CASE WHEN AI_Purpose IS NULL OR TRIM(AI_Purpose)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'AI_Usage_Hours_Per_Day', COUNT(*), SUM(CASE WHEN AI_Usage_Hours_Per_Day IS NULL OR TRIM(AI_Usage_Hours_Per_Day)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Tasks_Performed', COUNT(*), SUM(CASE WHEN Tasks_Performed IS NULL OR TRIM(Tasks_Performed)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Monthly_AI_Cost', COUNT(*), SUM(CASE WHEN Monthly_AI_Cost IS NULL OR TRIM(Monthly_AI_Cost)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Productivity_Score', COUNT(*), SUM(CASE WHEN Productivity_Score IS NULL THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Accuracy_Rating', COUNT(*), SUM(CASE WHEN Accuracy_Rating IS NULL THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Satisfaction_Score', COUNT(*), SUM(CASE WHEN Satisfaction_Score IS NULL THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Time_Saved_Hours_Per_Week', COUNT(*), SUM(CASE WHEN Time_Saved_Hours_Per_Week IS NULL OR TRIM(Time_Saved_Hours_Per_Week)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Work_or_Study_Hours_Per_Day', COUNT(*), SUM(CASE WHEN Work_or_Study_Hours_Per_Day IS NULL OR TRIM(Work_or_Study_Hours_Per_Day)='' THEN 1 ELSE 0 END) FROM t UNION ALL SELECT 'Would_Recommend', COUNT(*), SUM(CASE WHEN Would_Recommend IS NULL OR TRIM(Would_Recommend)='' THEN 1 ELSE 0 END) FROM t</parameter> <parameter name="purpose">Count null/blank values per column across all 19 data columns</parameter> <parameter name="source">raw</parameter> </invoke> <parameter name="x">1</parameter> <invoke name="x">