SELECT id, ROUND(score, 1) AS score FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY score DESC) AS rn FROM (SELECT participants.analyst AS id, res.overall_score AS score FROM results CROSS JOIN UNNEST(results.results) AS r(res))) WHERE rn = 1 ORDER BY score DESC;