SELECT results.participants.defender AS id, ROUND(res.pass_rate * 100, 1) AS "Pass Rate (%)", ROUND(res.time_used, 2) AS "Time (s)", res.score AS "Score", res.total_tasks AS "# Tasks" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.pass_rate DESC, res.time_used ASC;