I'm using two SUMs because you want two columns summed. The first (9+8+8+5) = 30, the second (1+1+1+1) = 4.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability