Club:Fairplay/statisches/test

{{#CSS: thead tr {background-color: ActiveCaption; color: CaptionText;}

     th, td {vertical-align: top; font-family: "Tahoma", Arial, Helvetica, sans-serif; font-size: 8pt; padding: 3px; }
     table, td {border: 1px solid silver;}
     table {border-collapse: collapse;}
     thead .col0 {width: 156px;}

.theadcol0 {width: 150px; color: navy; text-align: left;} .theadcol1 {width: 050px;} .theadcol2 {width: 050px;} .theadcol3 {width: 100px;} .theadcol4 {width: 050px;} .col1 {text-align: right;} .col2 {text-align: right;} .col3 {text-align: right;} .col4 {text-align: right;} }}

---

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;

---

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