SELECT
  t.participants.purple AS id,
  r.result.score AS score,
  r.result.total AS total,
  r.result.accuracy AS accuracy
FROM results t
CROSS JOIN UNNEST(t.results) AS r(result)
ORDER BY accuracy DESC, score DESC;