SELECT id, ROUND(AVG(CASE WHEN passed THEN 1 ELSE 0 END) * 100, 1) AS "Pass Rate %", ROUND(AVG(best_score) * 100, 1) AS "Avg Score", ROUND(AVG(total_attempts), 1) AS "Avg Attempts", COUNT(*) AS "# Runs" FROM (SELECT results.participants.purple AS id, res.detail.passed AS passed, res.detail.best_score AS best_score, res.detail.total_attempts AS total_attempts FROM results CROSS JOIN UNNEST(results.results) AS r(res)) GROUP BY id ORDER BY "Pass Rate %" DESC, "Avg Score" DESC;