SELECT results.participants.agent_under_test AS id, ROUND(AVG(res.a2_score), 3) AS "A2 Score", ROUND(AVG(res.safety), 3) AS "Safety", ROUND(AVG(res.security), 3) AS "Security", ROUND(AVG(res.reliability), 3) AS "Reliability", ROUND(AVG(res.compliance), 3) AS "Compliance", ROUND(AVG(res.defense_rate), 2) AS "Defense Rate", ROUND(1 - AVG(res.defense_rate), 2) AS "Attack Success Rate", MAX(res.num_tasks) AS "# Tasks" FROM results CROSS JOIN UNNEST(results.results) AS r(res) GROUP BY id ORDER BY "A2 Score" DESC;