SELECT id, ROUND(recall,2) AS "Recall", ROUND(precision,2) AS "Precision", ROUND(f1,2) AS "F1" FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY recall DESC, f1 DESC) AS rn FROM (SELECT results.participants.agent AS id, r.result.detail.participants.agent.recall AS recall, r.result.detail.participants.agent.precision AS precision, r.result.detail.participants.agent.f1 AS f1 FROM results CROSS JOIN UNNEST(results.results) AS r(result))) WHERE rn = 1 ORDER BY "Recall" DESC, "F1" DESC;