SELECT
    results.participants.solver AS id,
    res.total_runs AS "Total Runs",
    res.successful_runs AS "Successes",
    ROUND(res.success_rate * 100, 1) AS "Success %",
    ROUND(res.avg_loss, 2) AS "Avg Loss",
    ROUND(res.avg_steps, 1) AS "Avg Steps"
  FROM results
  CROSS JOIN UNNEST(results.results) AS r(res)
  ORDER BY "Success %" DESC;