SELECT id, ROUND(pass_rate,1) AS "Pass Rate (%)", ROUND(time_used/60.0,1) AS "Time (min)", total_tasks AS "Tasks (#)", ROUND(avg_tools_called,1) AS "Tools Called (Avg)" FROM (SELECT results.participants.agent AS id, r.res.pass_rate AS pass_rate, r.res.time_used AS time_used, r.res.total_tasks AS total_tasks, r.res.avg_tools_called AS avg_tools_called, ROW_NUMBER() OVER (PARTITION BY results.participants.agent ORDER BY r.res.pass_rate DESC, r.res.time_used ASC) AS rn FROM results CROSS JOIN UNNEST(results.results) AS r(res)) WHERE rn = 1 ORDER BY "Pass Rate (%)" DESC, "Time (min)" ASC;