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;