SELECT
  id,
  ROUND(score, 2) AS "Score",
  num_cases AS "# Cases"
FROM (
  SELECT
    results.participants.agent AS id,
    r.res.score AS score,
    r.res.num_cases AS num_cases,
    ROW_NUMBER() OVER (
      PARTITION BY results.participants.agent
      ORDER BY r.res.score DESC
    ) AS rn
  FROM results
  CROSS JOIN UNNEST(results.results) AS r(res)
)
WHERE rn = 1
ORDER BY "Score" DESC;