SELECT id, ROUND(average_score, 3) AS "Score", total_tasks AS "# Tasks" FROM ( SELECT results.participants.agent AS id, unnest.summary.average_score AS average_score, unnest.summary.total_tasks AS total_tasks, ROW_NUMBER() OVER ( PARTITION BY results.participants.agent ORDER BY unnest.summary.average_score DESC ) AS rn FROM results, UNNEST(results.results) ) WHERE rn = 1 ORDER BY "Score" DESC

SELECT results.participants.agent AS id, ROUND(unnest.summary.average_score, 3) AS "Score", unnest.summary.total_tasks AS "# Tasks", ROUND(unnest.summary.action_avg, 3) AS "Action Avg", ROUND(unnest.summary.argument_avg, 3) AS "Argument Avg", ROUND(unnest.summary.efficiency_avg, 3) AS "Efficiency Avg" FROM results, UNNEST(results.results) ORDER BY "Score" DESC