SELECT id, run_id AS "Run", ROUND(canonical_score * 100, 1) AS "Score (%)", ROUND(semantic_score * 100, 1) AS "Semantic (%)", ROUND(numeric_score * 100, 1) AS "Numeric (%)", ROUND(contradiction_rate * 100, 1) AS "Contradictions (%)", canonical_tasks AS "# Tasks" FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id, run_id ORDER BY canonical_score DESC) AS rn FROM (SELECT results.participants.agent AS id, results.run_id AS run_id, AVG(CASE WHEN res.source = 'canonical' THEN res.final_score END) AS canonical_score, AVG(CASE WHEN res.source = 'canonical' THEN res.semantic_score END) AS semantic_score, AVG(CASE WHEN res.source = 'canonical' THEN res.numeric_score END) AS numeric_score, AVG(CASE WHEN res.source = 'canonical' AND res.contradiction_violated THEN 1.0 WHEN res.source = 'canonical' THEN 0.0 END) AS contradiction_rate, COUNT(CASE WHEN res.source = 'canonical' THEN 1 END) AS canonical_tasks FROM results CROSS JOIN UNNEST(results.results) AS r(res) GROUP BY results.participants.agent, results.run_id)) WHERE rn = 1 AND canonical_tasks > 0 ORDER BY "Score (%)" DESC;

SELECT id, run_id AS "Run", ROUND(adversarial_score * 100, 1) AS "Score (%)", ROUND(semantic_score * 100, 1) AS "Semantic (%)", ROUND(numeric_score * 100, 1) AS "Numeric (%)", ROUND(contradiction_rate * 100, 1) AS "Contradictions (%)", adversarial_tasks AS "# Tasks" FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id, run_id ORDER BY adversarial_score DESC) AS rn FROM (SELECT results.participants.agent AS id, results.run_id AS run_id, AVG(CASE WHEN res.source = 'adversarial' THEN res.final_score END) AS adversarial_score, AVG(CASE WHEN res.source = 'adversarial' THEN res.semantic_score END) AS semantic_score, AVG(CASE WHEN res.source = 'adversarial' THEN res.numeric_score END) AS numeric_score, AVG(CASE WHEN res.source = 'adversarial' AND res.contradiction_violated THEN 1.0 WHEN res.source = 'adversarial' THEN 0.0 END) AS contradiction_rate, COUNT(CASE WHEN res.source = 'adversarial' THEN 1 END) AS adversarial_tasks FROM results CROSS JOIN UNNEST(results.results) AS r(res) GROUP BY results.participants.agent, results.run_id)) WHERE rn = 1 AND adversarial_tasks > 0 ORDER BY "Score (%)" DESC;