512. 游戏玩法分析 II-sql

select player_id, device_id from Activity
where (player_id, event_date) in (select player_id, min(event_date) as event_date from Activity group by Player_id)
group by player_id;

select player_id, device_id from Activity

where (player_id, event_date) in (select player_id, min(event_date) as event_date from Activity group by Player_id)

group by player_id;