add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
5.6.51
Records: 3  Duplicates: 0  Warnings: 0
player_id player_name player_dob player_ssn
1 Joe Sixpack 1995-10-15 X123456789
2 Seán Citizen 1994-02-02 Y987654321
3 Bill Person 1997-12-20 Z567891234
Records: 9  Duplicates: 0  Warnings: 0
rating_id player_id rating rating_date
1 1 3 2013-09-23
2 1 4 2016-04-07
3 1 5 2018-11-17
4 2 8 2015-09-23
5 2 7 2017-09-23
6 2 6 2020-01-03
7 3 15 2011-05-30
8 3 17 2012-02-11
9 3 14 2014-12-14
player_id current_rating_date
1 2018-11-17
2 2020-01-03
3 2014-12-14
player_id rating current_rating
1 5 2018-11-17
2 6 2020-01-03
3 14 2014-12-14
p_pid player_name player_dob player_ssn r_pid rating current_rating
1 Joe Sixpack 1995-10-15 X123456789 1 5 2018-11-17
2 Seán Citizen 1994-02-02 Y987654321 2 6 2020-01-03
3 Bill Person 1997-12-20 Z567891234 3 14 2014-12-14