SELECT id, ROUND(pass_rate * 100, 1) AS 'Pass Rate %', ROUND(avg_score, 1) AS '7D Score', total_tasks AS 'Tasks', total_passed AS 'Passed' FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY pass_rate DESC) AS rn   FROM ( SELECT r.participants.agent AS id, res.summary.pass_rate AS pass_rate, res.summary.avg_score AS avg_score, res.summary.total_tasks AS total_tasks, res.summary.total_passed AS total_passed FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ) ) WHERE rn = 1   ORDER BY pass_rate DESC, avg_score DESC;

SELECT r.participants.agent AS id, ROUND(COALESCE(res.dimension_averages.FUNCTIONAL, 0), 1) AS 'Functional', ROUND(COALESCE(res.dimension_averages.DRIFT_ADAPTATION, 0), 1) AS   'Drift Adapt', ROUND(COALESCE(res.dimension_averages.TOKEN_EFFICIENCY, 0), 1) AS 'Token Eff', ROUND(COALESCE(res.dimension_averages.QUERY_EFFICIENCY, 0), 1) AS 'Query Eff', ROUND(COALESCE(res.dimension_averages.ERROR_RECOVERY, 0), 1) AS 'Error Rec', ROUND(COALESCE(res.dimension_averages.TRAJECTORY_EFFICIENCY, 0), 1) AS 'Traj Eff', ROUND(COALESCE(res.dimension_averages.HALLUCINATION_RATE, 0), 1) AS 'Halluc' FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ORDER BY id;

SELECT r.participants.agent AS id, res.extension_metrics.drift_level AS 'Drift Level', res.extension_metrics.rot_level AS 'Rot Level', res.extension_metrics.org_type AS 'Org Type' FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ORDER BY id;