SELECT results.participants.agent AS id, ROUND(AVG(CASE WHEN r.res.task = 'portfolio' THEN r.res.score END), 4) AS "Portfolio", ROUND(AVG(CASE WHEN r.res.task = 'regime_detection' THEN r.res.score END), 4) AS "Regime Detection", ROUND(AVG(CASE WHEN r.res.task = 'arbitrage' THEN r.res.score END), 4) AS "Arbitrage", ROUND(AVG(CASE WHEN r.res.task = 'execution' THEN r.res.score END), 4) AS "Execution", ROUND(AVG(r.res.score), 4) AS "Overall Score" FROM results CROSS JOIN UNNEST(results.results) AS r(res) GROUP BY results.participants.agent ORDER BY "Overall Score" DESC;