SELECT id, ROUND(AVG(blended_f1), 3) AS "Blended F1", ROUND(AVG(f1), 3) AS "Product F1", ROUND(AVG(precision), 3) AS "Precision", ROUND(AVG(recall), 3) AS "Recall", COUNT(*) AS "Tests" FROM (SELECT results.participants.agent AS id, res.blended_f1 AS blended_f1, res.f1 AS f1, res.precision AS precision, res.recall AS recall FROM results CROSS JOIN UNNEST(results.results) AS r(res)) GROUP BY id ORDER BY "Blended F1" DESC