SELECT id, ROUND(pass_rate * 100, 1) AS "Accuracy (%)", ROUND(time_used, 1) AS "Time (s)", score AS "Score" FROM ( SELECT results.participants.agent AS id, res.pass_rate AS pass_rate, res.time_used AS time_used, res.score AS score FROM results CROSS JOIN UNNEST(results.results) AS r(res) ) ORDER BY "Accuracy (%)" DESC