<invoke name="query_sql"> <parameter name="purpose">Per-column missing (NULL or blank) count and percentage across all columns</parameter> <parameter name="sql">WITH t AS (SELECT * FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals) SELECT 'Age' AS column_name, COUNT(*) FILTER (WHERE Age IS NULL OR TRIM(Age)='') AS missing_count, ROUND(100.0*COUNT(*) FILTER (WHERE Age IS NULL OR TRIM(Age)='')/COUNT(*),2) AS pct_missing FROM t UNION ALL SELECT 'Gender', COUNT(*) FILTER (WHERE Gender IS NULL OR TRIM(Gender)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Gender IS NULL OR TRIM(Gender)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Country', COUNT(*) FILTER (WHERE Country IS NULL OR TRIM(Country)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Country IS NULL OR TRIM(Country)='')/COUNT(*),2) FROM t UNION ALL SELECT 'User_Type', COUNT(*) FILTER (WHERE User_Type IS NULL OR TRIM(User_Type)=''), ROUND(100.0*COUNT(*) FILTER (WHERE User_Type IS NULL OR TRIM(User_Type)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Education_Level', COUNT(*) FILTER (WHERE Education_Level IS NULL OR TRIM(Education_Level)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Education_Level IS NULL OR TRIM(Education_Level)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Profession', COUNT(*) FILTER (WHERE Profession IS NULL OR TRIM(Profession)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Profession IS NULL OR TRIM(Profession)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Monthly_Income', COUNT(*) FILTER (WHERE Monthly_Income IS NULL OR TRIM(Monthly_Income)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Monthly_Income IS NULL OR TRIM(Monthly_Income)='')/COUNT(*),2) FROM t UNION ALL SELECT 'AI_Tool', COUNT(*) FILTER (WHERE AI_Tool IS NULL OR TRIM(AI_Tool)=''), ROUND(100.0*COUNT(*) FILTER (WHERE AI_Tool IS NULL OR TRIM(AI_Tool)='')/COUNT(*),2) FROM t UNION ALL SELECT 'AI_Purpose', COUNT(*) FILTER (WHERE AI_Purpose IS NULL OR TRIM(AI_Purpose)=''), ROUND(100.0*COUNT(*) FILTER (WHERE AI_Purpose IS NULL OR TRIM(AI_Purpose)='')/COUNT(*),2) FROM t UNION ALL SELECT 'AI_Usage_Hours_Per_Day', COUNT(*) FILTER (WHERE AI_Usage_Hours_Per_Day IS NULL OR TRIM(AI_Usage_Hours_Per_Day)=''), ROUND(100.0*COUNT(*) FILTER (WHERE AI_Usage_Hours_Per_Day IS NULL OR TRIM(AI_Usage_Hours_Per_Day)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Monthly_AI_Cost', COUNT(*) FILTER (WHERE Monthly_AI_Cost IS NULL OR TRIM(Monthly_AI_Cost)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Monthly_AI_Cost IS NULL OR TRIM(Monthly_AI_Cost)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Productivity_Score', COUNT(*) FILTER (WHERE Productivity_Score IS NULL), ROUND(100.0*COUNT(*) FILTER (WHERE Productivity_Score IS NULL)/COUNT(*),2) FROM t UNION ALL SELECT 'Accuracy_Rating', COUNT(*) FILTER (WHERE Accuracy_Rating IS NULL), ROUND(100.0*COUNT(*) FILTER (WHERE Accuracy_Rating IS NULL)/COUNT(*),2) FROM t UNION ALL SELECT 'Satisfaction_Score', COUNT(*) FILTER (WHERE Satisfaction_Score IS NULL), ROUND(100.0*COUNT(*) FILTER (WHERE Satisfaction_Score IS NULL)/COUNT(*),2) FROM t UNION ALL SELECT 'Time_Saved_Hours_Per_Week', COUNT(*) FILTER (WHERE Time_Saved_Hours_Per_Week IS NULL OR TRIM(Time_Saved_Hours_Per_Week)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Time_Saved_Hours_Per_Week IS NULL OR TRIM(Time_Saved_Hours_Per_Week)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Work_or_Study_Hours_Per_Day', COUNT(*) FILTER (WHERE Work_or_Study_Hours_Per_Day IS NULL OR TRIM(Work_or_Study_Hours_Per_Day)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Work_or_Study_Hours_Per_Day IS NULL OR TRIM(Work_or_Study_Hours_Per_Day)='')/COUNT(*),2) FROM t UNION ALL SELECT 'Would_Recommend', COUNT(*) FILTER (WHERE Would_Recommend IS NULL OR TRIM(Would_Recommend)=''), ROUND(100.0*COUNT(*) FILTER (WHERE Would_Recommend IS NULL OR TRIM(Would_Recommend)='')/COUNT(*),2) FROM t ORDER BY missing_count DESC</parameter> <parameter name="source">raw</parameter> </invoke> id