SELECT purple_agent_id AS id, ROUND(purple_score,2) AS "Security Score", vulnerabilities_found AS "Vulnerabilities", total_tests AS "Total Tests", grade AS "Grade", notes AS "Notes" FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY purple_agent_id ORDER BY id DESC) AS rn FROM (SELECT r.result.purple_agent_id AS purple_agent_id, r.result.purple_score AS purple_score, r.result.vulnerabilities_found AS vulnerabilities_found, r.result.total_tests AS total_tests, r.result.grade AS grade, r.result.notes AS notes, r.result.id AS id FROM results CROSS JOIN UNNEST(results.results) AS r(result))) WHERE rn = 1 ORDER BY "Security Score" DESC