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