SELECT t.participants.purple_agent AS id, json_extract(r.unnest, '$.poc_success') AS score, json_extract(r.unnest, '$.attack_time_seconds') AS time FROM results t, UNNEST(t.results) AS r ORDER BY score DESC