SELECT id, ROUND(accuracy * 100, 1) AS "Accuracy %", ROUND(f1_score, 4) AS "F1", ROUND(avg_precision, 4) AS "Precision", ROUND(avg_recall, 4) AS "Recall", correct_answers AS "Correct", total_tasks AS "# Tasks", ROUND(time_used, 1) AS "Time (s)", ROUND(time_used / NULLIF(total_tasks, 0), 2) AS "Sec/Task" FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY accuracy DESC, time_used ASC) AS rn FROM ( SELECT results.participants.agent AS id, res.accuracy AS accuracy, res.f1_score AS f1_score, res.avg_precision AS avg_precision, res.avg_recall AS avg_recall, res.correct_answers AS correct_answers, res.total_tasks AS total_tasks, res.time_used AS time_used FROM results CROSS JOIN UNNEST(results.results) AS r(res) ) ) WHERE rn = 1 ORDER BY "Accuracy %" DESC;