SELECT t.participants.purple_agent AS id, ROUND(r.result.accuracy * 100, 1) AS "Accuracy %", ROUND(r.result.retrieval_accuracy * 100, 1) AS "Response Accuracy %", ROUND(r.result.action_accuracy * 100, 1) AS "Action Accuracy %", ROUND(r.result.f1_score * 100, 1) AS "F1 %", CASE WHEN r.result.time_used >= 3600 THEN CONCAT(CAST(FLOOR(r.result.time_used / 3600) AS INT), 'h ', CAST(FLOOR((r.result.time_used % 3600) / 60) AS INT), 'm') WHEN r.result.time_used >= 60 THEN CONCAT(CAST(FLOOR(r.result.time_used / 60) AS INT), 'm ', CAST(FLOOR(r.result.time_used % 60) AS INT), 's') ELSE CONCAT(CAST(ROUND(r.result.time_used, 1) AS VARCHAR), 's') END AS "Time" FROM results t CROSS JOIN UNNEST(t.results) AS r(result) ORDER BY "Accuracy %" DESC, "F1 %" DESC;