SQL 玩家首次登陆设备的ID

题目来源：https://mp.weixin.qq.com/s/jWviL_AxLnmx784Ivtwg4A
题目
有如下一张表
Activity:
获取player首次登录设备的device_id，返回的结果如下：
代码

SELECT a1.player_id,a1.device_id
FROM activity a1,
(SELECT player_id,MIN(event_date) AS min_date
FROM activity
GROUP BY player_id) a2
WHERE a1.player_id=a2.player_id AND a1.event_date=a2.min_date;