Donnerstag, 21. April 2011

Tore pro Spiel

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
?
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">
Print this post

Keine Kommentare:

Kommentar veröffentlichen