select sum(whatever)
   from
      -- 10 tables, omitted --
   where
      -- whole pile of stuff omitted --
   group by
      -- another pile of things