Club:Fairplay/statisches/test

gegner	anzg	pts	quoti
zifnab	34	26.5	77.9
h2m2	36	26.5	73.6
alms	34	23.5	69.1
Priwet	8	5.5	68.8
Chessking22	6	4.0	66.7
nathanDERweise	26	17.0	65.4
Boeschinski	4	2.5	62.5
Diebfaenger	18	10.5	58.3
petraK	40	22.0	55.0
bumm	26	14.0	53.8
Lanja	8	4.0	50.0		Noel.S	4	2.0	50.0		mira2407	40	19.0	47.5		Quarkbeutel	26	12.0	46.2		Etez	26	12.0	46.2		SG1951SON	20	9.0	45.0		DJ_Baheiz	16	7.0	43.8		Klaus1998	6	2.0	33.3		kani	12	3.5	29.2		Lukas93	3	0.0	0.0		pyroman97	2	0.0	0.0

---

select gegner, count(gegner) as anzg, round(sum(ergebnisS)/2,1) as pts, round(count(TurnierNr)/2,1) as anzTurniere, round(100*round(sum(ergebnisS)/2/count(gegner),3),1) as quoti from partien group by gegner order by quoti desc, anzg desc, pts desc;

<thead> </thead> <tbody> </tbody>

gegner	anzg	pts	anzTurniere	quoti
zifnab	34	26,5	17,0	77,9
h2m2	36	26,5	18,0	73,6
alms	34	23,5	17,0	69,1
Priwet	8	5,5	4,0	68,8
Chessking22	6	4,0	3,0	66,7
nathanDERweise	26	17,0	13,0	65,4
Boeschinski	4	2,5	2,0	62,5
Diebfaenger	18	10,5	9,0	58,3
petraK	40	22,0	20,0	55,0
bumm	26	14,0	13,0	53,8
Lanja	8	4,0	4,0	50,0
Noel.S	4	2,0	2,0	50,0
mira2407	40	19,0	20,0	47,5
Quarkbeutel	26	12,0	13,0	46,2
Etez	26	12,0	13,0	46,2
SG1951SON	20	9,0	10,0	45,0
DJ_Baheiz	16	7,0	8,0	43,8
Klaus1998	6	2,0	3,0	33,3
kani	12	3,5	6,0	29,2
Lukas93	3	0,0	1,5	0,0
pyroman97	2	0,0	1,0	0,0