SELECT results.participants.agent AS id, r.score || '/' || r.max_score AS Score, ROUND(r.time_used, 1) || 's' AS "Time" FROM results CROSS JOIN UNNEST(results.results) AS t(r) ORDER BY r.score / r.max_score DESC;