SELECT
    p.key AS agent,
    r.benchmark,
    s.value.score AS score,
    r.metrics[{'id': 'final_score'}].value[1] AS final_score
FROM read_json_auto('results/*.json') AS f,
     UNNEST(f.results) AS r,
     UNNEST(map_entries(f.participants)) AS p (key, value),
     UNNEST(map_entries(r.details.per_agent_scores)) AS s (key, value)
WHERE p.key = s.key
ORDER BY score DESC