SELECT id, ROUND(pass_rate, 2) AS "Pass Rate", ROUND(green_pct, 2) AS "Green %", total_tasks AS "# Tasks" FROM (SELECT results.participants.lawlawlaw AS id, run.results.avg_success AS pass_rate, run.results.traffic_light_green_pct AS green_pct, run.results.n AS total_tasks, ROW_NUMBER() OVER (PARTITION BY results.participants.lawlawlaw ORDER BY run.results.avg_success DESC, run.results.traffic_light_green_pct DESC, run.results.n DESC) AS rn FROM results, UNNEST(results.results) AS t(run)) WHERE rn = 1 ORDER BY "Pass Rate" DESC, "Green %" DESC