SELECT results.participants.agent AS id, ROUND(AVG(res.score), 1) AS "Average Score", ROUND(AVG(res.conclusion_score), 1) AS "Conclusion", ROUND(AVG(res.stakeholder_score), 1) AS "Stakeholders", ROUND(AVG(res.framework_comparison_score), 1) AS "Frameworks", ROUND(AVG(res.conversation_turns), 1) AS "Avg Turns", ROUND(AVG(res.debate_iterations), 1) AS "Avg Debates", COUNT(res.score) AS "# Scenarios" FROM results CROSS JOIN UNNEST(results.results) AS r(res) GROUP BY results.participants.agent ORDER BY "Average Score" DESC;

SELECT results.participants.agent AS id, res.scenario AS "Scenario", res.score AS "Score", res.conclusion_score AS "Conclusion", res.stakeholder_score AS "Stakeholders", res.framework_comparison_score AS "Frameworks", res.conversation_turns AS "Turns", res.debate_iterations AS "Debates" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY results.participants.agent, res.score DESC;