SELECT
  results.participants.agent AS id,
  ROUND(100.0 * AVG(CASE WHEN res.metrics.success THEN 1 ELSE 0 END), 1) AS "Success Rate",
  ROUND(AVG(res.metrics.goal_condition_success_rate), 3) AS "Goal Condition SR",
  ROUND(AVG(res.metrics.steps), 1) AS "Avg Steps",
  ROUND(AVG(res.metrics.failures), 1) AS "Avg Failures",
  COUNT(*) AS "# Trials"
FROM results
CROSS JOIN UNNEST(results.results) AS r(res)
WHERE res.metrics IS NOT NULL
GROUP BY id
ORDER BY "Success Rate" DESC, "Goal Condition SR" DESC, "Avg Failures" ASC, "Avg Steps" ASC;