clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1044250 fiddles created (9457 in the last week).

create table test (sf_name varchar(50), finish_position int, official_rating int, datec date, bsp float, diff float )
 hidden batch(es)


insert into test values("Camanche Grey",11,NULL,'2013-09-18',72.53,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",4,NULL,'2013-11-08',12.50,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",3,NULL,'2014-02-27',24.00,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",6,65,'2014-04-24',32.00,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",13,63,'2014-05-05',109.06,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",1,59,'2014-07-04',4.16,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",2,65,'2014-08-04',5.10,-6.00)
 hidden batch(es)


insert into test values("Camanche Grey",12,68,'2014-10-28',55.00,-9.00)
 hidden batch(es)


insert into test values("Camanche Grey",9,62,'2014-12-09',110.89,-3.00)
 hidden batch(es)


insert into test values("Camanche Grey",5,65,'2015-01-08',61.07,-6.00)
 hidden batch(es)


insert into test values("Camanche Grey",7,60,'2015-01-29',12.54,-1.00)
 hidden batch(es)


insert into test values("Camanche Grey",11,65,'2015-04-08',15.50,-6.00)
 hidden batch(es)


insert into test values("Camanche Grey",5,63,'2015-04-22',36.07,-4.00)
 hidden batch(es)


insert into test values("Camanche Grey",1,60,'2015-07-14',4.25,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",9,60,'2015-08-04',5.30,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",8,56,'2016-01-22',22.67,4.00)
 hidden batch(es)


insert into test values("Camanche Grey",4,52,'2016-02-26',11.76,8.00)
 hidden batch(es)


insert into test values("Camanche Grey",7,50,'2016-03-31',4.30,10.00)
 hidden batch(es)


insert into test values("Camanche Grey",8,48,'2016-04-25',6.31,12.00)
 hidden batch(es)


insert into test values("Camanche Grey",4,56,'2016-07-12',9.50,4.00)
 hidden batch(es)


insert into test values("Camanche Grey",8,47,'2016-09-23',23.47,13.00)
 hidden batch(es)


insert into test values("Camanche Grey",9,52,'2017-06-20',114.54,8.00)
 hidden batch(es)


insert into test values("Camanche Grey",1,50,'2017-07-04',15.51,0.00)
 hidden batch(es)


insert into test values("Camanche Grey",3,55,'2017-07-20',5.29,-5.00)
 hidden batch(es)


insert into test values("Camanche Grey",3,48,'2017-07-29',15.51,2.00)
 hidden batch(es)


insert into test values("Camanche Grey",2,47,'2017-08-24',8.00,3.00)
 hidden batch(es)


insert into test values("Camanche Grey",10,38,'2018-01-12',17.70,12.00)
 hidden batch(es)


insert into test values("Camanche Grey",2,55,'2018-07-19',27.28,-5.00)
 hidden batch(es)


insert into test values("Camanche Grey",3,54,'2018-07-30',6.78,-4.00)
 hidden batch(es)


insert into test values("Camanche Grey",1,54,'2018-08-21',24.00,0.00)
 hidden batch(es)


select * from test
sf_name finish_position official_rating datec bsp diff
Camanche Grey 11 2013-09-18 72.53 0
Camanche Grey 4 2013-11-08 12.5 0
Camanche Grey 3 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
 hidden batch(es)