SELECT participants.agent AS id, ROUND(AVG(r.averages.totalScore), 2) AS Total, ROUND(AVG(r.averages.clarityScore), 2) AS Clarity, ROUND(AVG(r.averages.logicScore), 2) AS Logic, ROUND(AVG(r.averages.internalAlignment), 2) AS Align, ROUND(AVG(r.averages.narrativeFlow), 2) AS Flow, ROUND(AVG(r.averages.r2n_retention), 2) AS R2N_Ret, ROUND(AVG(r.averages.r2n_authenticity), 2) AS R2N_Auth, ROUND(AVG(r.averages.r2n_risk), 2) AS R2N_Risk, ROUND(AVG(r.averages.r2s_retention), 2) AS R2S_Ret, ROUND(AVG(r.averages.r2s_authenticity), 2) AS R2S_Auth, ROUND(AVG(r.averages.r2s_risk), 2) AS R2S_Risk, ROUND(AVG(r.averages.n2s_retention), 2) AS N2S_Ret, ROUND(AVG(r.averages.n2s_authenticity), 2) AS N2S_Auth, ROUND(AVG(r.averages.n2s_risk), 2) AS N2S_Risk FROM (SELECT participants, UNNEST(results) AS r FROM results) GROUP BY id ORDER BY Total DESC, id;