SELECT id, ROUND(pass_1,2) AS "Pass Rate", ROUND(time,2) AS "Time" FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY pass_1 DESC, time ASC) AS rn FROM (SELECT results.participants.agent AS id, res.pass_1 AS pass_1, res.time AS time FROM results CROSS JOIN UNNEST(results.results) AS r(res))) WHERE rn = 1 ORDER BY "Pass Rate" DESC;