Skip to content

Instantly share code, notes, and snippets.

@richardbenson

richardbenson/KillsByTeam

Created July 26, 2010 12:59
Show Gist options
  • Save richardbenson/490510 to your computer and use it in GitHub Desktop.
Save richardbenson/490510 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
KillsByTeam
SELECT UnitName, (
SUM( HostNationKIA ) + SUM( EnemyKIA ) + Sum( CivilianKIA )
) AS Kills
FROM war_diary
GROUP BY UnitName
ORDER BY Kills DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment