This is a test page
This is a test page
Here is a SQL statement:
select gpsDriverCodeFlag(driverRef) as driver,
(select avg(position) from gpsLapTimes where driverId = sd.driverId and year = sd.year) as avgPosition,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 1) as p1,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 2) as p2,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 3) as p3,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 4) as p4,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 5) as p5,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 6) as p6,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 7) as p7,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 8) as p8,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 9) as p9,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 10) as p10,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 11) as p11,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 12) as p12,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 13) as p13,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 14) as p14,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 15) as p15,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 16) as p16,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 17) as p17,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 18) as p18,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 19) as p19,
(select count(1) from gpsLapTimes where driverId = sd.driverId and year = sd.year and `position` = 20) as p20
from gpsSeasonDrivers sd
where year = 2022
order by avgPosition;
And here is some data…
LEC 🇲🇨 1.1455 143 20 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
VER 🇳🇱 2.3169 6 110 17 5 1 0 2 0 0 0 0 0 1 0 0 0 0 0 0 0
SAI 🇪🇸 3.2130 2 6 78 20 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
PER 🇲🇽 3.4634 14 26 20 84 15 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0
RUS 🇬🇧 4.8061 0 1 36 6 78 39 5 0 0 0 0 0 0 0 0 0 0 0 0 0
HAM 🇬🇧 6.0606 0 2 12 42 40 28 9 3 0 10 6 5 1 7 0 0 0 0 0 0
MAG 🇩🇰 9.1037 0 0 0 0 3 21 62 4 29 3 2 4 9 6 14 5 2 0 0 0
OCO 🇫🇷 9.1697 0 0 0 0 2 12 15 44 26 25 27 6 2 1 0 4 1 0 0 0
ALO 🇪🇸 9.5638 0 0 0 7 3 18 8 19 19 26 13 15 6 8 0 0 6 0 0 1
GAS 🇫🇷 10.1316 0 0 0 0 0 0 6 46 25 31 5 1 7 28 3 0 0 0 0 0
BOT 🇫🇮 10.4967 0 0 0 0 0 2 8 26 20 17 18 34 17 6 1 1 1 0 0 0
NOR 🇬🇧 11.2727 0 0 0 0 22 19 13 15 2 4 9 13 12 3 6 13 13 11 3 7
RIC 🇦🇺 12.5800 0 0 0 1 0 22 17 4 14 0 11 8 7 2 6 10 10 16 10 12
TSU 🇯🇵 12.6404 0 0 0 0 0 0 1 1 6 12 38 8 4 4 19 12 9 0 0 0
ZHO 🇨🇳 13.7758 0 0 0 0 0 0 0 3 4 3 13 17 38 32 18 11 21 4 1 0
ALB 🇹🇭 13.8025 0 0 0 0 0 0 18 0 1 17 11 9 8 7 21 30 23 11 4 2
STR 🇨🇦 13.8476 0 0 0 0 0 0 0 0 12 11 9 27 12 17 28 23 11 5 9 0
MSC 🇩🇪 14.1754 0 0 0 0 0 0 0 0 0 5 2 10 34 18 19 11 4 9 1 1
HUL 🇩🇪 15.7196 0 0 0 0 0 0 0 0 7 1 1 7 4 21 11 8 12 6 17 12
VET 🇩🇪 16.2273 0 0 0 0 0 0 0 0 0 0 0 1 1 0 3 9 4 1 3 0
LAT 🇨🇦 17.9141 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 12 32 45 28 10