Club:Fairplay/statisches/test: Unterschied zwischen den Versionen

Aus chessmail Wiki @novasign.ch
Zur Navigation springen Zur Suche springen
K
K
Zeile 34: Zeile 34:
 
|| pyroman97 || 2 || 0.0 || 0.0 ||
 
|| pyroman97 || 2 || 0.0 || 0.0 ||
 
|}
 
|}
 +
----
 +
<p style="font-family: monospace; white-space: pre;">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;</p>
 +
 +
    <table caption="partien (21 rows)">
 +
      <thead>
 +
        <tr>
 +
          <th class="col0">gegner</th>
 +
          <th class="col1">anzg</th>
 +
          <th class="col2">pts</th>
 +
          <th class="col3">anzTurniere</th>
 +
          <th class="col4">quoti</th>
 +
        </tr>
 +
      </thead>
 +
      <tbody>
 +
        <tr>
 +
          <td class="col0">zifnab</td>
 +
          <td class="col1">34</td>
 +
          <td class="col2">26,5</td>
 +
          <td class="col3">17,0</td>
 +
          <td class="col4">77,9</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">h2m2</td>
 +
          <td class="col1">36</td>
 +
          <td class="col2">26,5</td>
 +
          <td class="col3">18,0</td>
 +
          <td class="col4">73,6</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">alms</td>
 +
          <td class="col1">34</td>
 +
          <td class="col2">23,5</td>
 +
          <td class="col3">17,0</td>
 +
          <td class="col4">69,1</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Priwet</td>
 +
          <td class="col1">8</td>
 +
          <td class="col2">5,5</td>
 +
          <td class="col3">4,0</td>
 +
          <td class="col4">68,8</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Chessking22</td>
 +
          <td class="col1">6</td>
 +
          <td class="col2">4,0</td>
 +
          <td class="col3">3,0</td>
 +
          <td class="col4">66,7</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">nathanDERweise</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">17,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">65,4</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Boeschinski</td>
 +
          <td class="col1">4</td>
 +
          <td class="col2">2,5</td>
 +
          <td class="col3">2,0</td>
 +
          <td class="col4">62,5</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Diebfaenger</td>
 +
          <td class="col1">18</td>
 +
          <td class="col2">10,5</td>
 +
          <td class="col3">9,0</td>
 +
          <td class="col4">58,3</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">petraK</td>
 +
          <td class="col1">40</td>
 +
          <td class="col2">22,0</td>
 +
          <td class="col3">20,0</td>
 +
          <td class="col4">55,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">bumm</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">14,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">53,8</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Lanja</td>
 +
          <td class="col1">8</td>
 +
          <td class="col2">4,0</td>
 +
          <td class="col3">4,0</td>
 +
          <td class="col4">50,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Noel.S</td>
 +
          <td class="col1">4</td>
 +
          <td class="col2">2,0</td>
 +
          <td class="col3">2,0</td>
 +
          <td class="col4">50,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">mira2407</td>
 +
          <td class="col1">40</td>
 +
          <td class="col2">19,0</td>
 +
          <td class="col3">20,0</td>
 +
          <td class="col4">47,5</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Quarkbeutel</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">12,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">46,2</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Etez</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">12,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">46,2</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">SG1951SON</td>
 +
          <td class="col1">20</td>
 +
          <td class="col2">9,0</td>
 +
          <td class="col3">10,0</td>
 +
          <td class="col4">45,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">DJ_Baheiz</td>
 +
          <td class="col1">16</td>
 +
          <td class="col2">7,0</td>
 +
          <td class="col3">8,0</td>
 +
          <td class="col4">43,8</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Klaus1998</td>
 +
          <td class="col1">6</td>
 +
          <td class="col2">2,0</td>
 +
          <td class="col3">3,0</td>
 +
          <td class="col4">33,3</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">kani</td>
 +
          <td class="col1">12</td>
 +
          <td class="col2">3,5</td>
 +
          <td class="col3">6,0</td>
 +
          <td class="col4">29,2</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Lukas93</td>
 +
          <td class="col1">3</td>
 +
          <td class="col2">0,0</td>
 +
          <td class="col3">1,5</td>
 +
          <td class="col4">0,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">pyroman97</td>
 +
          <td class="col1">2</td>
 +
          <td class="col2">0,0</td>
 +
          <td class="col3">1,0</td>
 +
          <td class="col4">0,0</td>
 +
        </tr>
 +
      </tbody>
 +
    </table>

Version vom 21. Juni 2013, 21:23 Uhr

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