SELECT id, ROUND(pass_1,3) AS "Pass@1", ROUND(time,2) AS "Time (s)" 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)));