<invoke name="query_sql"> <parameter name="sql">WITH t AS (SELECT * FROM raw.Social_media_impact_on_life), u AS ( SELECT 'Gender' AS column_name, CAST(Gender AS VARCHAR) AS value FROM t UNION ALL SELECT 'Academic_Level', CAST(Academic_Level AS VARCHAR) FROM t UNION ALL SELECT 'Primary_Platform', CAST(Primary_Platform AS VARCHAR) FROM t UNION ALL SELECT 'Device_Type', CAST(Device_Type AS VARCHAR) FROM t UNION ALL SELECT 'Late_Night_Usage', CAST(Late_Night_Usage AS VARCHAR) FROM t UNION ALL SELECT 'Social_Comparison_Frequency', CAST(Social_Comparison_Frequency AS VARCHAR) FROM t UNION ALL SELECT 'Overall_Impact', CAST(Overall_Impact AS VARCHAR) FROM t UNION ALL SELECT 'Age', CAST(Age AS VARCHAR) FROM t) SELECT column_name, value, COUNT(*) AS n, ROUND(100.0*COUNT(*)/4500, 1) AS pct FROM u GROUP BY column_name, value ORDER BY column_name, n DESC</parameter> <parameter name="purpose">Value frequency for all categorical columns</parameter> </invoke>