SELECT agent_id AS id, COUNT(*) AS "Tasks", ROUND(AVG(r.scores.detection) * 100, 1) AS "Detection %", ROUND(AVG(r.scores.diagnosis) * 100, 1) AS "Diagnosis %", ROUND(AVG(r.scores.recovery) * 100, 1) AS "Recovery %", ROUND(AVG(r.scores.total), 1) AS "Total Score" FROM results CROSS JOIN UNNEST(results.results) AS t(r) WHERE r.scores.total IS NOT NULL GROUP BY agent_id ORDER BY "Total Score" DESC

SELECT agent_id AS id, r.category AS "Error Type", COUNT(*) AS "Tasks", ROUND(AVG(r.scores.total), 1) AS "Avg Score" FROM results CROSS JOIN UNNEST(results.results) AS t(r) WHERE r.scores.total IS NOT NULL GROUP BY agent_id, r.category ORDER BY agent_id, "Avg Score" DESC

SELECT agent_id AS id, r.difficulty AS "Difficulty", r.task_id AS "Task", r.category AS "Category", ROUND(r.scores.detection * 100, 0) AS "Det%", ROUND(r.scores.diagnosis * 100, 0) AS "Diag%", ROUND(r.scores.recovery * 100, 0) AS "Rec%", ROUND(r.scores.total, 1) AS "Total" FROM results CROSS JOIN UNNEST(results.results) AS t(r) WHERE r.scores.total IS NOT NULL ORDER BY r.scores.total DESC