SELECT ts.participants.ctf_solver as id, result.challenges_evaluated, (SELECT COUNT(*) FROM UNNEST(result.results) AS c(ch) WHERE c.ch.score >= 1.0) AS challenges_completed_successfully, result.overall_score, (SELECT string_agg(c.ch.challenge, ', ' ORDER BY c.ch.challenge) FROM UNNEST(result.results) AS c(ch)) AS challenges FROM results ts CROSS JOIN UNNEST(ts.results) AS r(result) GROUP BY id, result ORDER BY challenges, result.overall_score DESC;