SELECT results.participants.evaluee AS id, res.overall_score AS 'Score (%)', res.passed_scenarios AS Passed, res.failed_scenarios AS Failed FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.overall_score DESC

SELECT results.participants.evaluee AS id, res.level1_dar AS 'DAR (%)', res.total_scenarios AS Tests FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.level1_dar ASC

SELECT results.participants.evaluee AS id, res.level2_srs AS 'SRS (%)', res.total_scenarios AS Tests FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.level2_srs DESC