[LeetCode] 511. Game Play Analysis I

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT player_id
     , event_date AS first_login
FROM (
    SELECT *
         , ROW_NUMBER () OVER (PARTITION BY player_id ORDER BY event_date) AS row_n
    FROM Activity) AS player_login
WHERE row_n = 1