Tore pro Spiel

Tore im Fußball
20. April 2011
Fußballreise Nürnberg
28. April 2011

Die nachfolgende Grafik entsteht aus einem Aufruf von Google Chart gefüttert mit den Parametern aus den danach folgenden SQL-Abfragen.




Sql Tore

1
2
3
4
5
6
Tore
SELECT LEFT(ROUND(SUM(TORERAPID) * 1.0 / COUNT(ID_GAME), 2), 4) AS Tore
FROM RAPID_GAMES
WHERE (ID_COMPETITION = N'NM')
GROUP BY ID_COMPETITION, SEASON
ORDER BY SEASON


Sql Gegentore

Mitgliederversammlung am 20.5.2019 mit:
Präsident Michael Krammer, Geschäftsführer Christoph Peschek und Präsidiumsmitglied Josef Kamper
Nur für Mitglieder!
1
2
3
4
5
6
Gegentore
SELECT LEFT(ROUND(SUM(TOREGEGENER) * 1.0 / COUNT(ID_GAME), 2), 4) AS Tore
FROM RAPID_GAMES
WHERE (ID_COMPETITION = N'NM')
GROUP BY ID_COMPETITION, SEASON
ORDER BY SEASON


Sql Tordifferenz

1
2
3
4
5
6
Tordifferenz
SELECT LEFT(ROUND((SUM(TORERAPID) - SUM(TOREGEGNER)) * 1.0 / COUNT(ID_GAME), 2), 4) AS Tore
FROM RAPID_GAMES
WHERE (ID_COMPETITION = N'NM')
GROUP BY ID_COMPETITION, SEASON
ORDER BY SEASON
html Google-Aufruf

1
2
Google-Aufruf
<img src="http://chart.apis.google.com/chart?chtt=Tore pro Spiel des SK Rapid&chdl=Tore|Gegentore&chg=5,20&chco=008800,444444&chxt=x,y&chm=b,96C4FB,0,1,0|t*,aaaa00,0,0,20,,h|t*,aaaa00,0,1,20,,h|t*,aaaa00,0,4,20,,h|t*,aaaa00,0,5,20,,h|t*,aaaa00,0,7,20,,h|t*,aaaa00,0,8,20,,h|t*,aaaa00,0,9,20,,h|t*,aaaa00,0,11,20,,h|t*,aaaa00,0,17,20,,h|t*,aaaa00,0,18,20,,h|t*,aaaa00,0,23,20,,h|t*,aaaa00,0,26,20,,h|t*,aaaa00,0,28,20,,h|t*,aaaa00,0,29,20,,h|t*,aaaa00,0,34,20,,h|t*,aaaa00,0,36,20,,h|t*,aaaa00,0,39,20,,h|t*,aaaa00,0,40,20,,h|t*,aaaa00,0,42,20,,h|t*,aaaa00,0,44,20,,h|t*,aaaa00,0,45,20,,h|t*,aaaa00,0,48,20,,h|t*,aaaa00,0,52,20,,h|t*,aaaa00,0,55,20,,h|t*,aaaa00,0,56,20,,h|t*,aaaa00,0,70,20,,h|t*,aaaa00,0,71,20,,h|t*,aaaa00,0,75,20,,h|t*,aaaa00,0,76,20,,h|t*,aaaa00,0,84,20,,h|t*,aaaa00,0,93,20,,h|t*,aaaa00,0,96,20,,h&chxl=0:|1911|1920|1930|1940|1950|1960|1970|1980|1990|2000|2010|1:|0|1|2|3|4|5&cht=lc&chs=640x250&chds=0,5&chd=t:2.91,3.28,2.83,2.56,4.83,3.56,2.56,3.72,3.23,3.31,2.77,3.00,2.50,2.23,2.35,3.15,3.15,2.59,3.05,3.56,3.18,2.95,3.67,4.32,2.64,2.32,3.28,3.33,3.57,4.56,2.17,2.95,2.06,3.55,4.50,2.73,3.06,3.39,3.35,5.12,4.12,3.62,3.69,3.35,3.58,3.85,3.58,3.92,3.35,1.88,2.23,2.00,2.65,1.62,2.46,2.77,2.88,2.13,1.73,2.17,1.30,1.67,2.18,1.58,1.53,2.00,2.11,1.47,1.28,1.92,1.92,2.35,2.37,2.83,2.89,2.61,2.25,1.86,1.92,1.86,1.61,1.47,1.06,1.75,1.89,1.92,1.17,1.39,1.64,1.72,1.03,1.11,1.39,1.86,1.42,1.53,1.92,2.39,2.22,1.19|1.41,0.94,1.44,1.78,1.44,1.56,1.28,0.83,1.32,1.50,1.77,1.62,2.18,1.77,2.19,1.69,1.77,1.41,1.32,1.83,1.77,1.59,1.62,1.36,1.82,1.82,1.06,1.61,1.71,1.61,1.67,2.41,2.33,1.36,1.09,1.64,1.28,1.61,1.65,1.54,1.50,1.85,1.65,1.81,1.42,1.65,1.50,1.12,1.23,1.62,1.23,1.08,1.04,0.81,0.85,1.12,0.92,1.13,1.17,1.20,0.77,1.03,0.97,1.14,1.39,1.08,1.19,1.11,1.11,1.19,1.19,0.58,0.60,1.00,0.86,1.19,1.11,1.11,1.44,1.14,1.11,1.42,1.17,1.39,1.06,1.00,1.00,0.69,0.81,1.00,1.36,1.06,1.31,0.86,1.14,1.36,1.00,1.28,1.06,0.89">
Tagebucheinträge per Mail zugesendet bekommen. Zur Anmeldung
Ausdrucken

Schreibe einen Kommentar