SELECT id, score, max_score, pass_rate AS "Pass Rate", passed FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY pass_rate DESC) AS rn FROM (SELECT results.participants.agent AS id, SUM(r.score) AS score, SUM(r.max_score) AS max_score, ROUND(SUM(r.score) * 100.0 / NULLIF(SUM(r.max_score), 0), 1) AS pass_rate, CAST(SUM(r.score) AS VARCHAR) || '/' || CAST(SUM(r.max_score) AS VARCHAR) AS passed FROM results CROSS JOIN LATERAL UNNEST(results.results) AS t(r) GROUP BY results.participants.agent, results.filename)) WHERE rn = 1 ORDER BY "Pass Rate" DESC, id ASC;