Invalid query : select gsOpp, tID, tname, city, sum(gsAttempts) as passes, sum(gsPassYards) as passyds, sum(gsPassTDs) as passtds, sum(gsRushes) as rushes, sum(gsRushYards) as rushyds, sum(gsRushTDs) as rushtds, (sum(gsPassYards)+sum(gsRushYards)) as total, sum(gsRushYards)/COUNT(DISTINCT(gsgUID)) as rushydsavg, sum(gsPassYards)/COUNT(DISTINCT(gsgUID)) as passydsavg, (sum(gsPassYards)+sum(gsRushYards))/COUNT(DISTINCT(gsgUID)) as totydsavg from tecmoteam, game_stats where gsOpp = tID AND gslUID = 1 AND gPlayoff = 0 AND tID > 0 group by tID order by Sacks desc, city asc