Benutzer:H2m2/ergebnistabellen/el2015/beendete Partien2/sql

select gameid,
gruppe AS Grp, 
runde AS Rde, 
playerFullnameWhite AS Weiss,
playerFullnameBlack AS Schwarz,
(0.5*playerPointsWhite) AS "pts.W",
(0.5*playerPointsBlack) AS "pts.S",
gameStartDate AS Start,
gameEndeDate AS Ende,
DATEDIFF(gameEndeDate,gameStartDate) AS Dauer,
partiemodus AS Spielart,
gameZugdauer as "Bd.Zeit",
gameELOSwhite AS "ELO.W",
gameELOSblack AS "ELO.S"
from einzelliga2015games
where (GIDstarted) and (!gameInProgress)
order by gruppe,runde;