SELECT agent AS id, summary.total AS "Total Tasks", ROUND(summary.avg_composite_score, 2) AS "Average Composite Score" FROM results ORDER BY "Average Composite Score" DESC;

PIVOT (SELECT t.agent AS id, ROUND(t.summary.avg_composite_score, 2) AS "Average Composite Score", r.results.problem_name AS problem_name, ROUND(r.results.composite_score, 1) AS composite_score FROM results t CROSS JOIN UNNEST(t.results) AS r(results)) ON problem_name USING first(composite_score) GROUP BY id, "Average Composite Score" ORDER BY id;