Formula Renault 2.0 Participation Data

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Season	Season ID	Unique Drivers	Total Race Entries	Num Drivers 12+ Weeks	Num Drivers 11 Weeks	Num Drivers 10 Weeks	Num Drivers 9 Weeks	Num Drivers 8 Weeks	Num Drivers 7 Weeks	Num Drivers 6 Weeks	Num Drivers 5 Weeks	Num Drivers 4 Weeks	Num Drivers 3 Weeks	Num Drivers 2 Weeks	Num Drivers 1 Week

2	2022 S1	3487	6081	34084	24	27	41	47	81	64	97	152	294	609	1248	3397
3	2021 S4	3368	4872	24500	23	24	38	50	90	66	77	137	208	458	971	2730
4	2021 S3	3250	4679	23194	20	23	25	46	78	49	76	129	238	453	917	2625
5	2021 S2	3136	5328	29704	40	26	45	52	76	64	73	154	266	487	1091	2954
6	2021 S1	3029	5176	27581	41	32	27	51	77	60	81	128	215	462	1067	2935
7	2020 S4	2926	4713	27145	53	43	36	58	77	51	99	135	223	440	981	2517
8	2020 S3	2831	5662	35780	89	36	57	81	55	65	128	184	282	556	1139	2990
9	2020 S2	2731	6122	34130	18	26	22	42	80	49	88	161	273	577	1372	3414
10	2020 S1	2632	2908	13993	18	20	16	30	61	32	48	75	111	277	577	1643
11	2019 S4	2545	2749	13585	13	18	23	22	64	25	41	76	134	260	589	1484
12	2019 S3	2454	2923	14560	12	14	22	24	57	25	39	71	137	289	602	1631
13	2019 S2	2361	2509	13292	9	13	14	37	63	32	51	72	125	234	459	1400
14	2019 S1	2275	2540	13589	14	8	15	29	62	25	33	65	116	256	525	1392
15	2018 S4	2215	2277	12821	15	23	17	30	63	34	40	62	117	207	450	1219
16	2018 S3	2133	2638	16724	18	18	30	45	69	37	70	60	133	228	491	1439
17	2018 S2	2053	2825	19339	27	31	39	56	75	37	68	110	133	295	576	1378
18	2018 S1	1971	2611	18337	24	29	26	61	86	25	64	77	136	264	508	1311
19	2017 S4	1902	2805	19806	29	39	33	42	78	37	76	92	138	285	579	1377
20	2017 S3	1838	2842	20560	26	23	38	47	72	26	60	114	151	254	565	1466
21	2017 S2	1772	3337	27460	42	37	51	75	114	73	100	124	205	355	677	1484
22	2017 S1	1706	3799	32203	54	50	57	92	129	76	116	155	242	439	764	1625
23	2016 S4	1647	3264	25890	34	55	39	56	95	69	84	142	209	309	651	1521
24	2016 S3	1596	3902	34566	49	50	66	101	163	92	116	190	262	423	746	1644
25	2016 S2	1542	5581	60330	105	114	117	178	330	168	229	292	457	658	1044	1889
26
27
28
29	QUERY
30	select b.season, a.seasonid,
31	count(distinct a.customerid) as unique_drivers,
32	sum(a.num_entries) as total_race_entries,
33	sum(if(a.num_weeks >= 12, 1, 0)) as drivers_12_weeks,
34	sum(if(a.num_weeks = 11, 1, 0)) as drivers_11_weeks,
35	sum(if(a.num_weeks = 10, 1, 0)) as drivers_10_weeks,
36	sum(if(a.num_weeks = 9, 1, 0)) as drivers_9_weeks,
37	sum(if(a.num_weeks = 8, 1, 0)) as drivers_8_weeks,
38	sum(if(a.num_weeks = 7, 1, 0)) as drivers_7_weeks,
39	sum(if(a.num_weeks = 6, 1, 0)) as drivers_6_weeks,
40	sum(if(a.num_weeks = 5, 1, 0)) as drivers_5_weeks,
41	sum(if(a.num_weeks = 4, 1, 0)) as drivers_4_weeks,
42	sum(if(a.num_weeks = 3, 1, 0)) as drivers_3_weeks,
43	sum(if(a.num_weeks = 2, 1, 0)) as drivers_2_weeks,
44	sum(if(a.num_weeks = 1, 1, 0)) as drivers_1_week
45	from
46	(select z.seasonid, z.customerid,
47	count(distinct z.raceweek) as num_weeks,
48	sum(z.num_official_races) as num_entries
49	from raceweek_driver_stats z
50	where seasonid in (select seasonid from seasons where seriesid = 269)
51	group by z.seasonid, z.customerid) a
52	join
53	(select distinct seasonid, year, quarter,
54	concat(replace(format(year, 0), ",",""), " S", format(quarter, 0)) as season
55	from seasons
56	where seriesid = 269) b
57	on a.seasonid = b.seasonid
58	group by b.season, a.seasonid
59	order by a.seasonid desc
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100