Leetcode_512_游戏玩法分析2_SQL

with t as (
select player_id, min(event_date) as d
from activity
group by player_id
)

select a.player_id, a.device_id
from activity as a, t
where a.event_date = t.d and a.player_id = t.player_id

select a1.player_id, a1.device_id
from activity as a1
where a1.event_date <= ALL(
    select a2.event_date
    from activity as a2
    where a1.player_id = a2.player_id
)

select player_id, device_id from (
	select
		player_id,
		device_id,
		dense_rank() over(partition by player_id order by event_date) as 排名
	from activity
) as temp where temp.排名 = 1;