<invoke name="tool_call"> <parameter name="reasoning">Compute the missing (NULL or blank) count and percentage for every column in one query, since step-1 only counted true NULLs and missed blank strings.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"WITH t AS (SELECT * FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals), n AS (SELECT COUNT(*) AS total FROM t) SELECT col, missing, ROUND(100.0*missing/total,2) AS pct_missing FROM (SELECT 'User_ID' col, COUNT(*) FILTER (WHERE NULLIF(TRIM(User_ID),'') IS NULL) missing FROM t UNION ALL SELECT 'Age', COUNT(*) FILTER (WHERE NULLIF(TRIM(Age),'') IS NULL) FROM t UNION ALL SELECT 'Gender', COUNT(*) FILTER (WHERE NULLIF(TRIM(Gender),'') IS NULL) FROM t UNION ALL SELECT 'Country', COUNT(*) FILTER (WHERE NULLIF(TRIM(Country),'') IS NULL) FROM t UNION ALL SELECT 'User_Type', COUNT(*) FILTER (WHERE NULLIF(TRIM(User_Type),'') IS NULL) FROM t UNION ALL SELECT 'Education_Level', COUNT(*) FILTER (WHERE NULLIF(TRIM(Education_Level),'') IS NULL) FROM t UNION ALL SELECT 'Profession', COUNT(*) FILTER (WHERE NULLIF(TRIM(Profession),'') IS NULL) FROM t UNION ALL SELECT 'Monthly_Income', COUNT(*) FILTER (WHERE NULLIF(TRIM(Monthly_Income),'') IS NULL) FROM t UNION ALL SELECT 'AI_Tool', COUNT(*) FILTER (WHERE NULLIF(TRIM(AI_Tool),'') IS NULL) FROM t UNION ALL SELECT 'AI_Purpose', COUNT(*) FILTER (WHERE NULLIF(TRIM(AI_Purpose),'') IS NULL) FROM t UNION ALL SELECT 'AI_Usage_Hours_Per_Day', COUNT(*) FILTER (WHERE NULLIF(TRIM(AI_Usage_Hours_Per_Day),'') IS NULL) FROM t UNION ALL SELECT 'Tasks_Performed', COUNT(*) FILTER (WHERE NULLIF(TRIM(Tasks_Performed),'') IS NULL) FROM t UNION ALL SELECT 'Monthly_AI_Cost', COUNT(*) FILTER (WHERE NULLIF(TRIM(Monthly_AI_Cost),'') IS NULL) FROM t UNION ALL SELECT 'Productivity_Score', COUNT(*) FILTER (WHERE Productivity_Score IS NULL) FROM t UNION ALL SELECT 'Accuracy_Rating', COUNT(*) FILTER (WHERE Accuracy_Rating IS NULL) FROM t UNION ALL SELECT 'Satisfaction_Score', COUNT(*) FILTER (WHERE Satisfaction_Score IS NULL) FROM t UNION ALL SELECT 'Time_Saved_Hours_Per_Week', COUNT(*) FILTER (WHERE NULLIF(TRIM(Time_Saved_Hours_Per_Week),'') IS NULL) FROM t UNION ALL SELECT 'Work_or_Study_Hours_Per_Day', COUNT(*) FILTER (WHERE NULLIF(TRIM(Work_or_Study_Hours_Per_Day),'') IS NULL) FROM t UNION ALL SELECT 'Would_Recommend', COUNT(*) FILTER (WHERE NULLIF(TRIM(Would_Recommend),'') IS NULL) FROM t) m, n ORDER BY missing DESC","purpose":"Missing count and percent for every column, treating blanks as missing"}</parameter> </invoke> _content