SELECT
      id,
      SUM(win) AS Wins,
      SUM(loss) AS Losses
    FROM (
      SELECT
        t.participants.defender AS id,
        r.result.passed_tests_count as win,
        r.result.failed_tests_count as loss
      FROM results t
      CROSS JOIN UNNEST(t.results) AS r(result))
    GROUP BY id
    ORDER BY wins DESC, losses ASC, id;