SELECT t.participants.medical_agent AS agent_id, COUNT(*) AS total_tasks, SUM(CASE WHEN r.result.passed THEN 1 ELSE 0 END) AS passed, SUM(CASE WHEN NOT r.result.passed THEN 1 ELSE 0 END) AS failed, ROUND(AVG(r.result.score), 2) AS avg_score, ROUND(AVG(r.result.score * 100.0 / r.result.max_score), 2) AS score_pct FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY t.participants.medical_agent ORDER BY avg_score DESC