SELECT id, ROUND(success, 1) AS "Avg Success %", ROUND(diversification, 1) AS "Diversification", ROUND(risk, 1) AS "Risk", ROUND(return_score, 1) AS "Return", scenarios AS "Scenarios" FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY success DESC) AS rn FROM ( SELECT results.participants.portfolio_constructor AS id, res.aggregate_scores.probability_of_success AS success, res.aggregate_scores.diversification_score AS diversification, res.aggregate_scores.risk_score AS risk, res.aggregate_scores.return_score AS return_score, res.num_scenarios AS scenarios FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE res.aggregate_scores IS NOT NULL ) ) WHERE rn = 1 ORDER BY success DESC