By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
player_id | event_date | player_id | event_date |
---|---|---|---|
1 | 2017-06-25 | 1 | 2016-03-01 |
1 | 2016-05-02 | 1 | 2016-03-01 |
1 | 2016-03-01 | 1 | 2016-03-01 |
1 | 2017-06-25 | 1 | 2016-05-02 |
1 | 2016-05-02 | 1 | 2016-05-02 |
1 | 2017-06-25 | 1 | 2017-06-25 |
3 | 2018-07-03 | 3 | 2016-03-02 |
3 | 2016-03-02 | 3 | 2016-03-02 |
3 | 2018-07-03 | 3 | 2018-07-03 |
player_id | event_date | games_played_so_far |
---|---|---|
1 | 2016-03-01 | 5 |
1 | 2016-05-02 | 11 |
1 | 2017-06-25 | 12 |
3 | 2016-03-02 | 0 |
3 | 2018-07-03 | 5 |