{
    "action": "tool_call",
    "reasoning": "Compute NULL-or-blank counts and percentages for every data column in one query. Cast each column to VARCHAR so TRIM works on the numeric columns too.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH t AS (SELECT * FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals) SELECT col, missing, ROUND(100.0*missing/(SELECT COUNT(*) FROM t),2) AS pct_missing FROM (SELECT 'User_ID' col, COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(User_ID AS VARCHAR)),'') IS NULL) missing FROM t UNION ALL SELECT 'Age', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Age AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Gender', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Gender AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Country', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Country AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'User_Type', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(User_Type AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Education_Level', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Education_Level AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Profession', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Profession AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Monthly_Income', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Monthly_Income AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'AI_Tool', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(AI_Tool AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'AI_Purpose', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(AI_Purpose AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'AI_Usage_Hours_Per_Day', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(AI_Usage_Hours_Per_Day AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Tasks_Performed', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Tasks_Performed AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Monthly_AI_Cost', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Monthly_AI_Cost AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Productivity_Score', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Productivity_Score AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Accuracy_Rating', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Accuracy_Rating AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Satisfaction_Score', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Satisfaction_Score AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Time_Saved_Hours_Per_Week', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Time_Saved_Hours_Per_Week AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Work_or_Study_Hours_Per_Day', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Work_or_Study_Hours_Per_Day AS VARCHAR)),'') IS NULL) FROM t UNION ALL SELECT 'Would_Recommend', COUNT(*) FILTER (WHERE NULLIF(TRIM(CAST(Would_Recommend AS VARCHAR)),'') IS NULL) FROM t) ORDER BY missing DESC, col",
        "purpose": "Count NULL or blank values per column and the share of the 300 rows missing",
        "source": "raw"
    }
}