SELECT results.participants.navigator AS id, ROUND(SUM(try_cast(json_extract_string(to_json(r), '$.score') AS DOUBLE)), 2) AS score FROM results CROSS JOIN UNNEST(results.results) AS t(r) GROUP BY id ORDER BY score DESC;