Equilibrium: Contest - World First world-first

SELECT
    row_number() OVER (ORDER BY p.endPlayed ASC) as position,
    p.pgcrId,
    p.data.Response as Response
FROM pgcr.parsed p
WHERE p.referenceId = 1754635208  -- Equilibrium: Contest
  AND p.completed = 1
  AND p.completionReason = 0
ORDER BY p.endPlayed ASC