SELECT id, ROUND(pass_rate*100,1) AS "Pass Rate", ROUND(run_time_s,1) AS "Time", tasks_attempted AS "# Tasks" FROM (SELECT id, pass_rate, run_time_s, tasks_attempted, ROW_NUMBER() OVER (PARTITION BY id ORDER BY pass_rate DESC, run_time_s ASC NULLS LAST) rn FROM (SELECT participants.player_w AS id, COALESCE(try_cast(json_extract_string(results,'$.time_s') AS DOUBLE),try_cast(json_extract_string(results,'$.time') AS DOUBLE),try_cast(json_extract_string(results,'$.elapsed_s') AS DOUBLE),try_cast(json_extract_string(results,'$.elapsed') AS DOUBLE),try_cast(json_extract_string(results,'$.duration_s') AS DOUBLE),try_cast(json_extract_string(results,'$.duration') AS DOUBLE)) AS run_time_s, COUNT(*) AS tasks_attempted, SUM(CASE WHEN r.winner='player_w' THEN 1 ELSE 0 END)::DOUBLE/COUNT(*) AS pass_rate FROM results CROSS JOIN UNNEST(results) AS t(r) GROUP BY 1,2 UNION ALL SELECT participants.player_b AS id, COALESCE(try_cast(json_extract_string(results,'$.time_s') AS DOUBLE),try_cast(json_extract_string(results,'$.time') AS DOUBLE),try_cast(json_extract_string(results,'$.elapsed_s') AS DOUBLE),try_cast(json_extract_string(results,'$.elapsed') AS DOUBLE),try_cast(json_extract_string(results,'$.duration_s') AS DOUBLE),try_cast(json_extract_string(results,'$.duration') AS DOUBLE)) AS run_time_s, COUNT(*) AS tasks_attempted, SUM(CASE WHEN r.winner='player_b' THEN 1 ELSE 0 END)::DOUBLE/COUNT(*) AS pass_rate FROM results CROSS JOIN UNNEST(results) AS t(r) GROUP BY 1,2)) WHERE rn=1 ORDER BY "Pass Rate" DESC, "Time" ASC NULLS LAST;