SELECT id, ROUND(total_score, 2) AS Total, ROUND(CAST(json_extract(to_json(task_metrics), '$.throw_a_snowball.score') AS DOUBLE), 2) AS throw_a_snowball, ROUND(CAST(json_extract(to_json(task_metrics), '$.look_at_the_sky.score') AS DOUBLE), 2) AS look_at_the_sky, ROUND(CAST(json_extract(to_json(task_metrics), '$.stacking_acacia_fence.score') AS DOUBLE), 2) AS stacking_acacia_fence, ROUND(CAST(json_extract(to_json(task_metrics), '$.drop_an_item.score') AS DOUBLE), 2) AS drop_an_item FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY total_score DESC) AS rn FROM ( SELECT COALESCE(results.participants.agent, results.participants['agent'], 'unknown') AS id, res.total_score AS total_score, res.task_metrics AS task_metrics FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE res.task_category = 'motion' ) ) WHERE rn = 1 ORDER BY Total DESC;