Invalid query : select pID, first, last, sum(gsAttempts) as Attempts, sum(gsComps) as Comps, sum(gsComps)/sum(gsAttempts)*100 as compPerc, sum(gsPassYards) as PassYards, sum(gsPassTDs) as TDs, sum(gsINTs) as INTs, ((GREATEST(0, LEAST(2.375,((((sum(gsComps) / sum(gsAttempts)) * 100) - 30) * .05))) + GREATEST(0, LEAST(2.375,(((sum(gsPassYards) / sum(gsAttempts)) - 3) * .25))) + LEAST(2.375, ((sum(gsPassTDs) / sum(gsAttempts)) *20)) + GREATEST(0, (2.375 -((sum(gsINTs) / sum(gsAttempts)) * 25))))*50/3) AS nfl_rating, sum(gsRushes) as rushes, sum(gsRushYards) as rushyds, sum(gsRushTDs) as rushtds from tecmoplayer, game_stats, tecmoteam where gslUID = 1 AND pID = gspUID AND tID = gsTeam AND gPlayoff = 0 AND pos = 0 AND gsAttempts > 0 group by gspUID order by Avg desc, last asc