在gameList表中(player_id, event_date)是主键,如何显示每个玩家(player_id)首次登录的设备号(device_id),并同时显示玩家ID(player_id)?
player_id | device_id | event_date | games_played |
111 | 21 | 2020-03-01 | 5 |
111 | 21 | 2020-01-02 | 6 |
212 | 33 | 2020-09-03 | 1 |
322 | 11 | 2020-01-21 | 0 |
322 | 44 | 2020-03-02 | 5 |