<invoke name="tool_call"> <parameter name="reasoning">One UNION query over raw to get top values and frequencies for each main categorical column (top 5 each).</parameter> <parameter name="tool">query_sql</parameter> <parameter name="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"}</parameter> </invoke>