{
    "action": "tool_call",
    "reasoning": "One UNION query over raw to get the top 5 values and their frequency share for each main categorical column.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH u AS (SELECT 'Gender' AS column_name, Gender AS value FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'User_Type', User_Type FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Education_Level', Education_Level FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'AI_Tool', AI_Tool FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'AI_Purpose', AI_Purpose FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals UNION ALL SELECT 'Would_Recommend', Would_Recommend FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals), c AS (SELECT column_name, value, COUNT(*) AS n FROM u GROUP BY column_name, value), r AS (SELECT *, ROUND(100.0*n/SUM(n) OVER (PARTITION BY column_name),1) AS pct, ROW_NUMBER() OVER (PARTITION BY column_name ORDER BY n DESC, value) AS rk, COUNT(*) OVER (PARTITION BY column_name) AS distinct_values FROM c) SELECT column_name, value, n, pct, rk, distinct_values FROM r WHERE rk<=5 ORDER BY column_name, rk",
        "purpose": "Top 5 values and frequency share for each main categorical column",
        "source": "raw"
    }
}