MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table  test (sf_name varchar(50), finish_position int, official_rating int, datec date, bsp float, diff float )
insert into test values("Camanche Grey",11,NULL,'2013-09-18',72.53,0.00)
insert into test values("Camanche Grey",4,NULL,'2013-11-08',12.50,0.00)
insert into test values("Camanche Grey",3,NULL,'2014-02-27',24.00,0.00)
insert into test values("Camanche Grey",6,65,'2014-04-24',32.00,0.00)
insert into test values("Camanche Grey",13,63,'2014-05-05',109.06,0.00)
insert into test values("Camanche Grey",1,59,'2014-07-04',4.16,0.00)
insert into test values("Camanche Grey",2,65,'2014-08-04',5.10,-6.00)
insert into test values("Camanche Grey",12,68,'2014-10-28',55.00,-9.00)
insert into test values("Camanche Grey",9,62,'2014-12-09',110.89,-3.00)
insert into test values("Camanche Grey",5,65,'2015-01-08',61.07,-6.00)
insert into test values("Camanche Grey",7,60,'2015-01-29',12.54,-1.00)
insert into test values("Camanche Grey",11,65,'2015-04-08',15.50,-6.00)
insert into test values("Camanche Grey",5,63,'2015-04-22',36.07,-4.00)
insert into test values("Camanche Grey",1,60,'2015-07-14',4.25,0.00)
insert into test values("Camanche Grey",9,60,'2015-08-04',5.30,0.00)
insert into test values("Camanche Grey",8,56,'2016-01-22',22.67,4.00)
insert into test values("Camanche Grey",4,52,'2016-02-26',11.76,8.00)
insert into test values("Camanche Grey",7,50,'2016-03-31',4.30,10.00)
insert into test values("Camanche Grey",8,48,'2016-04-25',6.31,12.00)
insert into test values("Camanche Grey",4,56,'2016-07-12',9.50,4.00)
insert into test values("Camanche Grey",8,47,'2016-09-23',23.47,13.00)
insert into test values("Camanche Grey",9,52,'2017-06-20',114.54,8.00)
insert into test values("Camanche Grey",1,50,'2017-07-04',15.51,0.00)
insert into test values("Camanche Grey",3,55,'2017-07-20',5.29,-5.00)
insert into test values("Camanche Grey",3,48,'2017-07-29',15.51,2.00)
insert into test values("Camanche Grey",2,47,'2017-08-24',8.00,3.00)
insert into test values("Camanche Grey",10,38,'2018-01-12',17.70,12.00)
insert into test values("Camanche Grey",2,55,'2018-07-19',27.28,-5.00)
insert into test values("Camanche Grey",3,54,'2018-07-30',6.78,-4.00)
insert into test values("Camanche Grey",1,54,'2018-08-21',24.00,0.00)
select * from test


sf_name
finish_position
official_rating
datec
bsp
diff


Camanche Grey
11
null
2013-09-18
72.53
0

Camanche Grey
4
null
2013-11-08
12.5
0

Camanche Grey
3
null
2014-02-27
24
0

Camanche Grey
6
65
2014-04-24
32
0

Camanche Grey
13
63
2014-05-05
109.06
0

Camanche Grey
1
59
2014-07-04
4.16
0

Camanche Grey
2
65
2014-08-04
5.1
-6

Camanche Grey
12
68
2014-10-28
55
-9

Camanche Grey
9
62
2014-12-09
110.89
-3

Camanche Grey
5
65
2015-01-08
61.07
-6

Camanche Grey
7
60
2015-01-29
12.54
-1

Camanche Grey
11
65
2015-04-08
15.5
-6

Camanche Grey
5
63
2015-04-22
36.07
-4

Camanche Grey
1
60
2015-07-14
4.25
0

Camanche Grey
9
60
2015-08-04
5.3
0

Camanche Grey
8
56
2016-01-22
22.67
4

Camanche Grey
4
52
2016-02-26
11.76
8

Camanche Grey
7
50
2016-03-31
4.3
10

Camanche Grey
8
48
2016-04-25
6.31
12

Camanche Grey
4
56
2016-07-12
9.5
4

Camanche Grey
8
47
2016-09-23
23.47
13

Camanche Grey
9
52
2017-06-20
114.54
8

Camanche Grey
1
50
2017-07-04
15.51
0

Camanche Grey
3
55
2017-07-20
5.29
-5

Camanche Grey
3
48
2017-07-29
15.51
2

Camanche Grey
2
47
2017-08-24
8
3

Camanche Grey
10
38
2018-01-12
17.7
12

Camanche Grey
2
55
2018-07-19
27.28
-5

Camanche Grey
3
54
2018-07-30
6.78
-4

Camanche Grey
1
54
2018-08-21
24
0

sf_name	finish_position	official_rating	datec	bsp	diff
Camanche Grey	11	null	2013-09-18	72.53	0
Camanche Grey	4	null	2013-11-08	12.5	0
Camanche Grey	3	null	2014-02-27	24	0
Camanche Grey	6	65	2014-04-24	32	0
Camanche Grey	13	63	2014-05-05	109.06	0
Camanche Grey	1	59	2014-07-04	4.16	0
Camanche Grey	2	65	2014-08-04	5.1	-6
Camanche Grey	12	68	2014-10-28	55	-9
Camanche Grey	9	62	2014-12-09	110.89	-3
Camanche Grey	5	65	2015-01-08	61.07	-6
Camanche Grey	7	60	2015-01-29	12.54	-1
Camanche Grey	11	65	2015-04-08	15.5	-6
Camanche Grey	5	63	2015-04-22	36.07	-4
Camanche Grey	1	60	2015-07-14	4.25	0
Camanche Grey	9	60	2015-08-04	5.3	0
Camanche Grey	8	56	2016-01-22	22.67	4
Camanche Grey	4	52	2016-02-26	11.76	8
Camanche Grey	7	50	2016-03-31	4.3	10
Camanche Grey	8	48	2016-04-25	6.31	12
Camanche Grey	4	56	2016-07-12	9.5	4
Camanche Grey	8	47	2016-09-23	23.47	13
Camanche Grey	9	52	2017-06-20	114.54	8
Camanche Grey	1	50	2017-07-04	15.51	0
Camanche Grey	3	55	2017-07-20	5.29	-5
Camanche Grey	3	48	2017-07-29	15.51	2
Camanche Grey	2	47	2017-08-24	8	3
Camanche Grey	10	38	2018-01-12	17.7	12
Camanche Grey	2	55	2018-07-19	27.28	-5
Camanche Grey	3	54	2018-07-30	6.78	-4
Camanche Grey	1	54	2018-08-21	24	0