SELECT t.participants.agent AS id, r.result.detail.levels_completed AS 'Levels Completed', r.result.detail.levels_attempted AS 'Levels Attempted', ROUND(r.result.detail.success_rate * 100, 1) AS 'Success Rate %', ROUND(r.result.detail.avg_turns_per_level, 1) AS 'Avg Turns', ROUND(r.result.detail.total_time_seconds, 1) AS 'Total Time (s)' FROM results t CROSS JOIN UNNEST(t.results) AS r(result) ORDER BY r.result.detail.levels_completed DESC, r.result.detail.success_rate DESC