SELECT id, AVG(final_wealth) AS avg_wealth, AVG(final_health) AS avg_health, COUNT(*) AS games_played FROM ( SELECT participants.player_1 AS id, unnest(results).detail.final_wealth.player_1 AS final_wealth, unnest(results).detail.final_health.player_1 AS final_health FROM results UNION ALL SELECT participants.player_2 AS id, unnest(results).detail.final_wealth.player_2 AS final_wealth, unnest(results).detail.final_health.player_2 AS final_health FROM results ) GROUP BY id ORDER BY avg_wealth DESC, avg_health DESC