Fetching algorithms...
Fetching algorithms...
| player_id | device_id | event_date | games_played |
|---|---|---|---|
| 1 | 2 | 2016-03-01 | 5 |
| 1 | 2 | 2016-05-02 | 6 |
| 2 | 3 | 2017-06-25 | 1 |
| 3 | 1 | 2016-03-02 | 0 |
| 3 | 4 | 2018-07-03 | 5 |
| player_id | first_login |
|---|---|
| 1 | 2016-03-01 |
| 2 | 2017-06-25 |
| 3 | 2016-03-02 |
For player_id = 1, the event dates are '2016-03-01' and '2016-05-02'. The earliest of these is '2016-03-01'.
For player_id = 2, there is only one event date: '2017-06-25'. This is therefore their first login date.
For player_id = 3, the event dates are '2016-03-02' and '2018-07-03'. The earliest of these is '2016-03-02'.
The output combines these first login dates for each unique player.