SUM(A+ SUM(B) - SUM(C)) doesn't really make sense. Better to just write SUM(A+B-C) or SUM(A)+SUM(B)-SUM(C) -- the two are different because of the treatment of NULL values.