Invalid query : select franchise, gsOpp, tttID, ttName, ttCity as 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 standings, game_stats where gsoppfranchise = franchise AND gslUID = 1 AND gslUID = ttlUID AND ttsUID = gsSeason AND gPlayoff = 0 AND tttID > 0 group by franchise order by DINTs desc, city asc