Equilibrium: Contest - Duo 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
  AND p.playerCount = 3
  -- Exactly 2 "real" players: played >= 2 min OR got at least 1 kill
  AND arrayCount(
    e -> e.values['timePlayedSeconds'].basic.value >= 120
      OR e.values['kills'].basic.value > 0,
    p.data.Response.entries
  ) = 2
ORDER BY p.endPlayed ASC