Skip to content

512. Game Play Analysis II 👍

1
2
3
4
5
6
7
SELECT DISTINCT
  player_id,
  FIRST_VALUE(device_id) OVER(
    PARTITION by player_id
    ORDER BY event_date
  ) AS device_id
FROM Activity;