SELECT t.participants.purple_agent AS id, ROUND(r.result.accuracy * 100, 1) AS "Accuracy %", ROUND(r.result.avg_precision * 100, 1) AS "Precision %", ROUND(r.result.avg_recall * 100, 1) AS "Recall %", ROUND(r.result.f1_score * 100, 1) AS "F1 %", r.result.correct_answers AS Correct, r.result.total_tasks AS Total, ROUND(r.result.time_used, 1) AS "Time (s)" FROM results t CROSS JOIN UNNEST(t.results) AS r(result) ORDER BY "Accuracy %" DESC, "F1 %" DESC, "Time (s)" ASC;