SELECT results.participants."purple-comtrade-baseline-v2" AS id, ROUND(AVG(r.score_total), 1) AS "Score", COUNT(*) AS "Tasks", CASE WHEN AVG(r.score_total) >= 80.0 THEN 'PASS' ELSE 'FAIL' END AS "Pass" FROM results CROSS JOIN UNNEST(results.results[1]) AS t(r) GROUP BY results.participants."purple-comtrade-baseline-v2" ORDER BY "Score" DESC;

SELECT results.participants."purple-comtrade-baseline-v2" AS id, ROUND(AVG(COALESCE(r.score_breakdown.correctness, 0)), 1) AS "Correctness /30", ROUND(AVG(COALESCE(r.score_breakdown.completeness, 0)), 1) AS "Completeness /15", ROUND(AVG(COALESCE(r.score_breakdown.robustness, 0)), 1) AS "Robustness /15", ROUND(AVG(COALESCE(r.score_breakdown.efficiency, 0)), 1) AS "Efficiency /15", ROUND(AVG(COALESCE(r.score_breakdown.data_quality, 0)), 1) AS "Data Quality /15", ROUND(AVG(COALESCE(r.score_breakdown.observability, 0)), 1) AS "Observability /10", ROUND(AVG(r.score_total), 1) AS "Total /100" FROM results CROSS JOIN UNNEST(results.results[1]) AS t(r) GROUP BY results.participants."purple-comtrade-baseline-v2" ORDER BY AVG(r.score_total) DESC;