{
    "action": "tool_call",
    "reasoning": "Profile missing values per column in one query. UNION ALL is used instead of UNPIVOT to stay within the executor's allowed syntax.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT 'Age' AS column_name, COUNT(*)-COUNT(Age) AS missing_count, ROUND(100.0*(COUNT(*)-COUNT(Age))/COUNT(*),2) AS pct_missing FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Gender', COUNT(*)-COUNT(Gender), ROUND(100.0*(COUNT(*)-COUNT(Gender))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Country', COUNT(*)-COUNT(Country), ROUND(100.0*(COUNT(*)-COUNT(Country))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'User_Type', COUNT(*)-COUNT(User_Type), ROUND(100.0*(COUNT(*)-COUNT(User_Type))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Education_Level', COUNT(*)-COUNT(Education_Level), ROUND(100.0*(COUNT(*)-COUNT(Education_Level))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Profession', COUNT(*)-COUNT(Profession), ROUND(100.0*(COUNT(*)-COUNT(Profession))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Monthly_Income', COUNT(*)-COUNT(Monthly_Income), ROUND(100.0*(COUNT(*)-COUNT(Monthly_Income))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'AI_Tool', COUNT(*)-COUNT(AI_Tool), ROUND(100.0*(COUNT(*)-COUNT(AI_Tool))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'AI_Purpose', COUNT(*)-COUNT(AI_Purpose), ROUND(100.0*(COUNT(*)-COUNT(AI_Purpose))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'AI_Usage_Hours_Per_Day', COUNT(*)-COUNT(AI_Usage_Hours_Per_Day), ROUND(100.0*(COUNT(*)-COUNT(AI_Usage_Hours_Per_Day))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Monthly_AI_Cost', COUNT(*)-COUNT(Monthly_AI_Cost), ROUND(100.0*(COUNT(*)-COUNT(Monthly_AI_Cost))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Productivity_Score', COUNT(*)-COUNT(Productivity_Score), ROUND(100.0*(COUNT(*)-COUNT(Productivity_Score))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Accuracy_Rating', COUNT(*)-COUNT(Accuracy_Rating), ROUND(100.0*(COUNT(*)-COUNT(Accuracy_Rating))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Satisfaction_Score', COUNT(*)-COUNT(Satisfaction_Score), ROUND(100.0*(COUNT(*)-COUNT(Satisfaction_Score))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Time_Saved_Hours_Per_Week', COUNT(*)-COUNT(Time_Saved_Hours_Per_Week), ROUND(100.0*(COUNT(*)-COUNT(Time_Saved_Hours_Per_Week))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Work_or_Study_Hours_Per_Day', COUNT(*)-COUNT(Work_or_Study_Hours_Per_Day), ROUND(100.0*(COUNT(*)-COUNT(Work_or_Study_Hours_Per_Day))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Would_Recommend', COUNT(*)-COUNT(Would_Recommend), ROUND(100.0*(COUNT(*)-COUNT(Would_Recommend))/COUNT(*),2) FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals ORDER BY pct_missing DESC",
        "purpose": "Render missing count and percent per column",
        "source": "raw"
    }
}