SELECT agent_id, AVG(case when status = '✅ Fixed' or status = '✅ Safe' then 1.0 else 0.0 end) as accuracy, COUNT(*) as total_runs FROM results GROUP BY agent_id ORDER BY accuracy DESC

SELECT agent_id, SUM(case when scenario = 'Chest Pain' and triage_level = 1 then 1 else 0 end) / SUM(case when scenario = 'Chest Pain' then 1 else 0 end) as safety_score FROM results GROUP BY agent_id