SELECT id, split AS "Split", ROUND(pass_rate, 1) AS "Pass Rate", ROUND(time_used, 1) AS "Time (s)", CAST(score AS BIGINT) AS "Correct", CAST(max_score AS BIGINT) AS "# Tasks" FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY pass_rate DESC, time_used ASC) AS rn FROM (SELECT results.participants.agent AS id, r.res.split AS split, CAST(r.res.pass_rate AS DOUBLE) AS pass_rate, CAST(r.res.time_used_sec AS DOUBLE) AS time_used, CAST(r.res.score AS DOUBLE) AS score, CAST(r.res.max_score AS DOUBLE) AS max_score FROM results CROSS JOIN UNNEST(results.results) AS r(res))) WHERE rn = 1 ORDER BY "Pass Rate" DESC, "Time (s)" ASC, id