[Linus F]

Nachdem ich jetzt auch ein bisschen SQL gelernt habe dachte ich mir, ich fange auch an ein paar Statistiken aus der WCA-Datenbank zu erstellen   Spezieller Dank gilt Gregor, der mir bei gewissen Startschwierigkeiten geholfen hat

Meisten Solves (deutsche Teilnehmer) (Click to View)

Platz	Name	Solves	DNFs
1	Sébastien Auroux	11633	523
2	Jan Bentlage	8672	380
3	Laura Ohrndorf	5081	345
4	Cornelius Dieckmann	4391	251
5	Andreas Pohl	3901	393
6	Leon Schmidtchen	3569	49
7	Björn Korbanka	3367	105
8	Wilhelm Kilders	3131	153
9	Linus Fresz	2858	247
10	Lucas Garron	2758	231
11	Nora Christ	2656	170
12	Michael Kristel	2648	69
13	Moritz Karl	2452	114
14	Niklas Spies	2203	136
15	Lucas Wesche	2192	91
16	Fabian Auroux	2185	133
17	Emanuel Rheinert	2173	121
18	Sebastian Weyer	2081	50
19	Philipp Weyer	2025	38
20	Finn Ickler	1868	49
21	Carsten Matheus	1819	48
22	Markus Pirzer	1789	268
23	Marcel Peters	1778	104
24	Lasse Korbanka	1759	40
25	Adrian Lehmann	1755	228
26	Martin Kraut	1662	63
27	Bennet Wichmann	1622	79
28	Kai Jiptner	1589	148
29	Stefan Pochmann	1588	80
30	Sebastian Werb	1555	111
31	Timo Ludwig	1514	101
32	Kevin Gerhardt	1434	65
33	Helmut Heilig	1431	54
34	Jan Smarschevski	1413	30
35	Alexander Springhorn	1400	44
36	Jens Diewald	1378	95
37	Maximilian Deimel	1354	22
38	Max Hahnbück	1330	61
39	Patrick Kern	1321	74
40	Henri Gerber	1262	71
41	Fabian Simon	1249	68
42	Tim Habermaas	1237	48
43	Willi Mickein	1212	47
44	Tobias Droste	1205	71
45	Tobias Christlieb	1204	70
46	Robin Blöhm	1188	44
47	Jascha Bakarinow	1164	22
48	Simon Kalhofer	1136	54
49	Oliver Fritz	1120	28
50	Fritz Löhr	1107	105
51	Jakob Obleser	1088	49
52	Ottfried Kejs	1087	59
53	Ramón Dersch	1083	11
54	Nils Feuer	1077	33
55	Manuel Guse	1059	71
56	Jonas Brzenczek	1054	18
57	Karl Choi	1053	78
58	Ludwig Choi	1042	54
59	Berit Brüster	1029	105
60	Maximilian Neitzel	1021	128
61	Andreas Gröbmayr	992	65
62	Dominik Beese	966	38
63	Tim Schädel	936	28
64	Gregor Billing	934	143
65	Patrick Hetco	923	46
66	Alexander Botz	900	61
67	Simon Stannek	897	7
68	Moritz Patzelt	890	40
69	Vincent Bruns	886	30
70	Axel Häck	860	166
71	Julian Höfler	840	28
72	Jorge Ströh	805	6
73	Monika Zimmermann	781	85
74	Lukas Lange	766	14
75	Andres Flügel	746	13
76	Emil Schwarz	723	31
77	Jonas Schober	719	41
78	Huy Dao	706	52
79	Heike Zbierski	700	58
80	Felix König	690	46
81	Elias Fischer	677	30
82	Nico Wrodarczyk	655	10
83	Philipp Roth	653	12
84	Sebastian Häfner	646	48
85	Ricky Meiler	641	27
86	Constantin Lüske	631	21
87	Kai Gabriel	602	21
88	Fin Thiessen	587	48
89	Daniel Becker	582	35
90	Florian Harrer	581	8
91	Joe Nowak	569	15
92	Philip Gonzalez	569	33
93	Yannick Richter	568	19
94	Jonathan Leistner	563	12
95	Reiner Thomsen	562	19
96	Marco Vorländer	549	12
97	Florian Kreyssig	544	27
98	Florian Weingarten	544	37
99	Christian Baier	543	8
100	Jessica Lohe	543	35

Code:

SELECT  personName, Count(value1 > 0 OR NULL) + Count(value2 > 0 OR NULL) + Count(value3 > 0 OR NULL) + Count(value4 > 0 OR NULL) + Count(value5 > 0 OR NULL) AS solves, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs
FROM Results
WHERE personCountryId = 'Germany'
GROUP BY personName
ORDER BY solves DESC
Limit 100

Für die folgenden zwei habe ich alle deutschen Teilnehmer genommen, die >300 Solves haben.

höchste DNF-Quote (DNF/solves) (Click to View)

Platz	Name	Solves	DNFs	Verhältnis (prozentual)
1	Axel Häck	860	166	19.3023
2	Gregor Billing	934	143	15.3105
3	Markus Pirzer	1789	268	14.9804
4	Christopher Tolksdorf	359	48	13.3705
5	Adrian Lehmann	1755	228	12.9915
6	Maximilian Neitzel	1021	128	12.5367
7	Monika Zimmermann	781	85	10.8835
8	Jörg Seidler	457	48	10.5033
9	Dennis Strehlau	526	55	10.4563
10	Kim Kattelans	386	40	10.3627
11	Berit Brüster	1029	105	10.2041
12	Andreas Pohl	3901	393	10.0743
13	Fritz Löhr	1107	105	9.4851
14	Kai Jiptner	1589	148	9.3140
15	Benjamin Brundzats	421	38	9.0261
16	Raffael Ort	529	47	8.8847
17	Linus Fresz	2858	247	8.6424
18	Leonard Ewerbeck	426	36	8.4507
19	Lucas Garron	2758	231	8.3756
20	Heike Zbierski	700	58	8.2857
21	Fin Thiessen	587	48	8.1772
22	Sebastian Bauer	498	40	8.0321
23	Jan Dickmann	329	26	7.9027
24	Dennis Loose	383	29	7.5718
25	Sebastian Häfner	646	48	7.4303
26	Rafael Kerkenrath	485	36	7.4227
27	Karl Choi	1053	78	7.4074
28	Huy Dao	706	52	7.3654
29	David Kerkmann	316	23	7.2785
30	Sebastian Werb	1555	111	7.1383
31	Jens Diewald	1378	95	6.8940
32	Florian Weingarten	544	37	6.8015
33	Laura Ohrndorf	5081	345	6.7900
34	Alexander Botz	900	61	6.7778
35	Manuel Guse	1059	71	6.7044
36	Timo Ludwig	1514	101	6.6711
37	Felix König	690	46	6.6667
38	André Tillmans	316	21	6.6456
39	Frank Dumont	440	29	6.5909
40	Andreas Gröbmayr	992	65	6.5524
41	Jessica Lohe	543	35	6.4457
42	Nora Christ	2656	170	6.4006
43	Niklas Spies	2203	136	6.1734
44	Fabian Auroux	2185	133	6.0870
45	Daniel Becker	582	35	6.0137
46	Tobias Droste	1205	71	5.8921
47	Marcel Peters	1778	104	5.8493
48	Tobias Christlieb	1204	70	5.8140
49	Philip Gonzalez	569	33	5.7996
50	Cornelius Dieckmann	4391	251	5.7162
51	Jonas Schober	719	41	5.7024
52	Henri Gerber	1262	71	5.6260
53	Patrick Kern	1321	74	5.6018
54	Emanuel Rheinert	2173	121	5.5683
55	Fabian Simon	1249	68	5.4444
56	Ottfried Kejs	1087	59	5.4278
57	Daniel Mädler	344	18	5.2326
58	Ludwig Choi	1042	54	5.1823
59	Garret von Gaffron	351	18	5.1282
60	Jan Staubach	430	22	5.1163
61	Stefan Pochmann	1588	80	5.0378
62	Marvin Strehl	541	27	4.9908
63	Patrick Hetco	923	46	4.9837
64	Florian Kreyssig	544	27	4.9632
65	Wilhelm Kilders	3131	153	4.8866
66	Bennet Wichmann	1622	79	4.8705
67	Simon Kalhofer	1136	54	4.7535
68	Norbert Kotthoff	359	17	4.7354
69	Moritz Karl	2452	114	4.6493
70	Max Hahnbück	1330	61	4.5865
71	Kevin Gerhardt	1434	65	4.5328
72	Jakob Obleser	1088	49	4.5037
73	Sébastien Auroux	11633	523	4.4958
74	Moritz Patzelt	890	40	4.4944
75	Elias Fischer	677	30	4.4313
76	Jan Bentlage	8672	380	4.3819
77	Emil Schwarz	723	31	4.2877
78	Ricky Meiler	641	27	4.2122
79	Lucas Wesche	2192	91	4.1515
80	Dominik Beese	966	38	3.9337
81	Tim Habermaas	1237	48	3.8804
82	Willi Mickein	1212	47	3.8779
83	Martin Kraut	1662	63	3.7906
84	Helmut Heilig	1431	54	3.7736
85	Markus Wolf	458	17	3.7118
86	Robin Blöhm	1188	44	3.7037
87	Kai Retzmann	339	12	3.5398
88	Kai Gabriel	602	21	3.4884
89	Emil Mickein	527	18	3.4156
90	Christoph Zistler	324	11	3.3951
91	Vincent Bruns	886	30	3.3860
92	Reiner Thomsen	562	19	3.3808
93	Yannick Richter	568	19	3.3451
94	Julian Höfler	840	28	3.3333
95	Constantin Lüske	631	21	3.3281
96	Artur Holzmann	337	11	3.2641
97	Alexander Springhorn	1400	44	3.1429
98	Björn Korbanka	3367	105	3.1185
99	Nils Feuer	1077	33	3.0641
100	Tim Schädel	936	28	2.9915

Code:

SELECT personName, solves, dnfs, dnfs/solves *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR NULL) + Count(value2 > 0 OR NULL) + Count(value3 > 0 OR NULL) + Count(value4 > 0 OR NULL) + Count(value5 > 0 OR NULL)) AS solves, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs, personCountryId
FROM Results
GROUP BY personName
) AS x
WHERE solves > 300 AND personCountryId = 'Germany'
ORDER BY percentage DESC
Limit 100

Geringste DNF-Quote (DNFs/Solves) (Click to View)

Platz	Name	Solves	DNFs	Verhältnis (prozentual)
1	Christian Dirks	437	3	0.6865
2	Jorge Ströh	805	6	0.7453
3	Simon Stannek	897	7	0.7804
4	Ramón Dersch	1083	11	1.0157
5	Martin Brath	376	4	1.0638
6	Leon Schmidtchen	3569	49	1.3729
7	Florian Harrer	581	8	1.3769
8	Christian Baier	543	8	1.4733
9	Nico Wrodarczyk	655	10	1.5267
10	Maximilian Deimel	1354	22	1.6248
11	David Schult	428	7	1.6355
12	Andreas Farenbruch	305	5	1.6393
13	Jonas Brzenczek	1054	18	1.7078
14	Andres Flügel	746	13	1.7426
15	Lukas Lange	766	14	1.8277
16	Philipp Roth	653	12	1.8377
17	Philipp Weyer	2025	38	1.8765
18	Jascha Bakarinow	1164	22	1.8900
19	Konstantin Krämer	522	10	1.9157
20	Jan Smarschevski	1413	30	2.1231
21	Jonathan Leistner	563	12	2.1314
22	Dorian Stein	371	8	2.1563
23	Marco Vorländer	549	12	2.1858
24	Lasse Korbanka	1759	40	2.2740
25	Sebastian Weyer	2081	50	2.4027
26	Niklas Rentz	409	10	2.4450
27	Oliver Fritz	1120	28	2.5000
28	Michael Kristel	2648	69	2.6057
29	Finn Ickler	1868	49	2.6231
30	Joe Nowak	569	15	2.6362
31	Carsten Matheus	1819	48	2.6388
32	Frieder Klein	368	10	2.7174
33	Adrian Englhardt	325	9	2.7692
34	David Quach	351	10	2.8490
35	Tim Schädel	936	28	2.9915
36	Nils Feuer	1077	33	3.0641
37	Björn Korbanka	3367	105	3.1185
38	Alexander Springhorn	1400	44	3.1429
39	Artur Holzmann	337	11	3.2641
40	Constantin Lüske	631	21	3.3281
41	Julian Höfler	840	28	3.3333
42	Yannick Richter	568	19	3.3451
43	Reiner Thomsen	562	19	3.3808
44	Vincent Bruns	886	30	3.3860
45	Christoph Zistler	324	11	3.3951
46	Emil Mickein	527	18	3.4156
47	Kai Gabriel	602	21	3.4884
48	Kai Retzmann	339	12	3.5398
49	Robin Blöhm	1188	44	3.7037
50	Markus Wolf	458	17	3.7118
51	Helmut Heilig	1431	54	3.7736
52	Martin Kraut	1662	63	3.7906
53	Willi Mickein	1212	47	3.8779
54	Tim Habermaas	1237	48	3.8804
55	Dominik Beese	966	38	3.9337
56	Lucas Wesche	2192	91	4.1515
57	Ricky Meiler	641	27	4.2122
58	Emil Schwarz	723	31	4.2877
59	Jan Bentlage	8672	380	4.3819
60	Elias Fischer	677	30	4.4313
61	Moritz Patzelt	890	40	4.4944
62	Sébastien Auroux	11633	523	4.4958
63	Jakob Obleser	1088	49	4.5037
64	Kevin Gerhardt	1434	65	4.5328
65	Max Hahnbück	1330	61	4.5865
66	Moritz Karl	2452	114	4.6493
67	Norbert Kotthoff	359	17	4.7354
68	Simon Kalhofer	1136	54	4.7535
69	Bennet Wichmann	1622	79	4.8705
70	Wilhelm Kilders	3131	153	4.8866
71	Florian Kreyssig	544	27	4.9632
72	Patrick Hetco	923	46	4.9837
73	Marvin Strehl	541	27	4.9908
74	Stefan Pochmann	1588	80	5.0378
75	Jan Staubach	430	22	5.1163
76	Garret von Gaffron	351	18	5.1282
77	Ludwig Choi	1042	54	5.1823
78	Daniel Mädler	344	18	5.2326
79	Ottfried Kejs	1087	59	5.4278
80	Fabian Simon	1249	68	5.4444
81	Emanuel Rheinert	2173	121	5.5683
82	Patrick Kern	1321	74	5.6018
83	Henri Gerber	1262	71	5.6260
84	Jonas Schober	719	41	5.7024
85	Cornelius Dieckmann	4391	251	5.7162
86	Philip Gonzalez	569	33	5.7996
87	Tobias Christlieb	1204	70	5.8140
88	Marcel Peters	1778	104	5.8493
89	Tobias Droste	1205	71	5.8921
90	Daniel Becker	582	35	6.0137
91	Fabian Auroux	2185	133	6.0870
92	Niklas Spies	2203	136	6.1734
93	Nora Christ	2656	170	6.4006
94	Jessica Lohe	543	35	6.4457
95	Andreas Gröbmayr	992	65	6.5524
96	Frank Dumont	440	29	6.5909
97	André Tillmans	316	21	6.6456
98	Felix König	690	46	6.6667
99	Timo Ludwig	1514	101	6.6711
100	Manuel Guse	1059	71	6.7044

Code:

SELECT personName, solves, dnfs, dnfs/solves *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR NULL) + Count(value2 > 0 OR NULL) + Count(value3 > 0 OR NULL) + Count(value4 > 0 OR NULL) + Count(value5 > 0 OR NULL)) AS solves, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs, personCountryId
FROM Results
GROUP BY personName
) AS x
WHERE solves > 300 AND personCountryId = 'Germany'
ORDER BY percentage ASC
Limit 100

Hier findet man die internationalen Versionen der Statistiken.


EDIT: Beim genaueren nachdenken ist für die letzten zwei Statistiken wohl DNFs/Attempts sinnvoller, siehe Tabellen unten

Höchste DNF-Quote (Click to View)

Platzierung	Name	Attempts	DNFs	Verhältnis (prozentual)
1	Axel Häck	1026	166	16.1793
2	Gregor Billing	1077	143	13.2776
3	Markus Pirzer	2057	268	13.0287
4	Christopher Tolksdorf	407	48	11.7936
5	Adrian Lehmann	1983	228	11.4977
6	Maximilian Neitzel	1149	128	11.1401
7	Monika Zimmermann	866	85	9.8152
8	Jörg Seidler	505	48	9.5050
9	Dennis Strehlau	581	55	9.4664
10	Kim Kattelans	426	40	9.3897
11	Berit Brüster	1134	105	9.2593
12	Andreas Pohl	4294	393	9.1523
13	Fritz Löhr	1212	105	8.6634
14	Kai Jiptner	1737	148	8.5204
15	Benjamin Brundzats	459	38	8.2789
16	Raffael Ort	576	47	8.1597
17	Thomas Müller	308	25	8.1169
18	Andre Cichon	313	25	7.9872
19	Linus Fresz	3105	247	7.9549
20	Leonard Ewerbeck	462	36	7.7922
21	Lucas Garron	2989	231	7.7283
22	Heike Zbierski	758	58	7.6517
23	Fin Thiessen	635	48	7.5591
24	Sebastian Bauer	538	40	7.4349
25	Jan Dickmann	355	26	7.3239
26	Dennis Loose	412	29	7.0388
27	Sebastian Häfner	694	48	6.9164
28	Rafael Kerkenrath	521	36	6.9098
29	Karl Choi	1131	78	6.8966
30	Huy Dao	758	52	6.8602
31	David Kerkmann	339	23	6.7847
32	Sebastian Werb	1666	111	6.6627
33	Jens Diewald	1473	95	6.4494
34	Florian Weingarten	581	37	6.3683
35	Laura Ohrndorf	5426	345	6.3583
36	Alexander Botz	961	61	6.3476
37	Manuel Guse	1130	71	6.2832
38	Timo Ludwig	1615	101	6.2539
39	Felix König	736	46	6.2500
40	André Tillmans	337	21	6.2315
41	Frank Dumont	469	29	6.1834
42	Andreas Gröbmayr	1057	65	6.1495
43	Jessica Lohe	578	35	6.0554
44	Nora Christ	2826	170	6.0156
45	Niklas Spies	2339	136	5.8145
46	Fabian Auroux	2318	133	5.7377
47	Daniel Becker	617	35	5.6726
48	Tobias Droste	1276	71	5.5643
49	Marcel Peters	1882	104	5.5260
50	Tobias Christlieb	1274	70	5.4945
51	Felix Schliecker	310	17	5.4839
52	Philip Gonzalez	602	33	5.4817
53	Cornelius Dieckmann	4642	251	5.4072
54	Jonas Schober	760	41	5.3947
55	Henri Gerber	1333	71	5.3263
56	Patrick Kern	1395	74	5.3047
57	Emanuel Rheinert	2294	121	5.2746
58	Fabian Simon	1317	68	5.1632
59	Ottfried Kejs	1146	59	5.1483
60	Daniel Mädler	362	18	4.9724
61	Ludwig Choi	1096	54	4.9270
62	Garret von Gaffron	369	18	4.8780
63	Jan Staubach	452	22	4.8673
64	Stefan Pochmann	1668	80	4.7962
65	Marvin Strehl	568	27	4.7535
66	Patrick Hetco	969	46	4.7472
67	Florian Kreyssig	571	27	4.7285
68	Wilhelm Kilders	3284	153	4.6590
69	Bennet Wichmann	1701	79	4.6443
70	Simon Kalhofer	1190	54	4.5378
71	Norbert Kotthoff	376	17	4.5213
72	Moritz Karl	2566	114	4.4427
73	Max Hahnbück	1391	61	4.3853
74	Kevin Gerhardt	1499	65	4.3362
75	Jakob Obleser	1137	49	4.3096
76	Sébastien Auroux	12156	523	4.3024
77	Moritz Patzelt	930	40	4.3011
78	Elias Fischer	707	30	4.2433
79	Jan Bentlage	9052	380	4.1980
80	Emil Schwarz	754	31	4.1114
81	Ricky Meiler	668	27	4.0419
82	Lucas Wesche	2283	91	3.9860
83	Dominik Beese	1004	38	3.7849
84	Tim Habermaas	1285	48	3.7354
85	Willi Mickein	1259	47	3.7331
86	Martin Kraut	1725	63	3.6522
87	Helmut Heilig	1485	54	3.6364
88	Markus Wolf	475	17	3.5789
89	Robin Blöhm	1232	44	3.5714
90	Kai Retzmann	351	12	3.4188
91	Kai Gabriel	623	21	3.3708
92	Emil Mickein	545	18	3.3028
93	Christoph Zistler	335	11	3.2836
94	Vincent Bruns	916	30	3.2751
95	Reiner Thomsen	581	19	3.2702
96	Yannick Richter	587	19	3.2368
97	Julian Höfler	868	28	3.2258
98	Constantin Lüske	652	21	3.2209
99	Artur Holzmann	348	11	3.1609
100	Alexander Springhorn	1444	44	3.0471

Code:

SELECT personName, attempts, dnfs, dnfs/attempts *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR value1 = -1 OR NULL) + Count(value2 > 0 OR value2 = -1 OR NULL) + Count(value3 > 0 OR value3 = -1 OR NULL) + Count(value4 > 0 OR value4 = -1 OR NULL) + Count(value5 > 0 OR value5 = -1 OR NULL)) AS attempts, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs, personCountryId
FROM Results
GROUP BY personName
) AS x
WHERE attempts > 300 AND personCountryId = 'Germany'
ORDER BY percentage DESC
Limit 100

Geringste DNF-Quote (Click to View)

Platz	Name	Attempts	DNFs	Verhältnis (prozentual)
1	Christian Dirks	440	3	0.6818
2	Jorge Ströh	811	6	0.7398
3	Simon Stannek	904	7	0.7743
4	Ramón Dersch	1094	11	1.0055
5	Martin Brath	380	4	1.0526
6	Leon Schmidtchen	3618	49	1.3543
7	Florian Harrer	589	8	1.3582
8	Christian Baier	551	8	1.4519
9	Nico Wrodarczyk	665	10	1.5038
10	Maximilian Deimel	1376	22	1.5988
11	David Schult	435	7	1.6092
12	Andreas Farenbruch	310	5	1.6129
13	Jonas Brzenczek	1072	18	1.6791
14	Andres Flügel	759	13	1.7128
15	Lukas Lange	780	14	1.7949
16	Philipp Roth	665	12	1.8045
17	Philipp Weyer	2063	38	1.8420
18	Jascha Bakarinow	1186	22	1.8550
19	Konstantin Krämer	532	10	1.8797
20	Jan Smarschevski	1443	30	2.0790
21	Jonathan Leistner	575	12	2.0870
22	Dorian Stein	379	8	2.1108
23	Marco Vorländer	561	12	2.1390
24	Lasse Korbanka	1799	40	2.2235
25	Sebastian Weyer	2131	50	2.3463
26	Niklas Rentz	419	10	2.3866
27	Oliver Fritz	1148	28	2.4390
28	Michael Kristel	2717	69	2.5396
29	Finn Ickler	1917	49	2.5561
30	Joe Nowak	584	15	2.5685
31	Carsten Matheus	1867	48	2.5710
32	Frieder Klein	378	10	2.6455
33	Adrian Englhardt	334	9	2.6946
34	David Quach	361	10	2.7701
35	Tim Schädel	964	28	2.9046
36	Nils Feuer	1110	33	2.9730
37	Björn Korbanka	3472	105	3.0242
38	Alexander Springhorn	1444	44	3.0471
39	Artur Holzmann	348	11	3.1609
40	Constantin Lüske	652	21	3.2209
41	Julian Höfler	868	28	3.2258
42	Yannick Richter	587	19	3.2368
43	Reiner Thomsen	581	19	3.2702
44	Vincent Bruns	916	30	3.2751
45	Christoph Zistler	335	11	3.2836
46	Emil Mickein	545	18	3.3028
47	Kai Gabriel	623	21	3.3708
48	Kai Retzmann	351	12	3.4188
49	Robin Blöhm	1232	44	3.5714
50	Markus Wolf	475	17	3.5789
51	Helmut Heilig	1485	54	3.6364
52	Martin Kraut	1725	63	3.6522
53	Willi Mickein	1259	47	3.7331
54	Tim Habermaas	1285	48	3.7354
55	Dominik Beese	1004	38	3.7849
56	Lucas Wesche	2283	91	3.9860
57	Ricky Meiler	668	27	4.0419
58	Emil Schwarz	754	31	4.1114
59	Jan Bentlage	9052	380	4.1980
60	Elias Fischer	707	30	4.2433
61	Moritz Patzelt	930	40	4.3011
62	Sébastien Auroux	12156	523	4.3024
63	Jakob Obleser	1137	49	4.3096
64	Kevin Gerhardt	1499	65	4.3362
65	Max Hahnbück	1391	61	4.3853
66	Moritz Karl	2566	114	4.4427
67	Norbert Kotthoff	376	17	4.5213
68	Simon Kalhofer	1190	54	4.5378
69	Bennet Wichmann	1701	79	4.6443
70	Wilhelm Kilders	3284	153	4.6590
71	Florian Kreyssig	571	27	4.7285
72	Patrick Hetco	969	46	4.7472
73	Marvin Strehl	568	27	4.7535
74	Stefan Pochmann	1668	80	4.7962
75	Jan Staubach	452	22	4.8673
76	Garret von Gaffron	369	18	4.8780
77	Ludwig Choi	1096	54	4.9270
78	Daniel Mädler	362	18	4.9724
79	Ottfried Kejs	1146	59	5.1483
80	Fabian Simon	1317	68	5.1632
81	Emanuel Rheinert	2294	121	5.2746
82	Patrick Kern	1395	74	5.3047
83	Henri Gerber	1333	71	5.3263
84	Jonas Schober	760	41	5.3947
85	Cornelius Dieckmann	4642	251	5.4072
86	Philip Gonzalez	602	33	5.4817
87	Felix Schliecker	310	17	5.4839
88	Tobias Christlieb	1274	70	5.4945
89	Marcel Peters	1882	104	5.5260
90	Tobias Droste	1276	71	5.5643
91	Daniel Becker	617	35	5.6726
92	Fabian Auroux	2318	133	5.7377
93	Niklas Spies	2339	136	5.8145
94	Nora Christ	2826	170	6.0156
95	Jessica Lohe	578	35	6.0554
96	Andreas Gröbmayr	1057	65	6.1495
97	Frank Dumont	469	29	6.1834
98	André Tillmans	337	21	6.2315
99	Felix König	736	46	6.2500
100	Timo Ludwig	1615	101	6.2539

Code:

SELECT personName, attempts, dnfs, dnfs/attempts *100 AS percentage
FROM
(
SELECT personName, (Count(value1 > 0 OR value1 = -1 OR NULL) + Count(value2 > 0 OR value2 = -1 OR NULL) + Count(value3 > 0 OR value3 = -1 OR NULL) + Count(value4 > 0 OR value4 = -1 OR NULL) + Count(value5 > 0 OR value5 = -1 OR NULL)) AS attempts, Count(value1 = -1 OR NULL) + Count(value2 = -1 OR NULL) + Count(value3 = -1 OR NULL) + Count(value4 = -1 OR NULL) + Count(value5 = -1 OR NULL) AS dnfs, personCountryId
FROM Results
GROUP BY personName
) AS x
WHERE attempts > 300 AND personCountryId = 'Germany'
ORDER BY percentage ASC
Limit 100