求和！

Question

sum(case when (dbo.[invoice-line].[db-id]='RCHQ' and substring(dbo.invoice.[entity-code],2,3)='419' and substring(dbo.invoice.[entity-code],5,2)<>'27' and substring(dbo.invoice.[entity-code],5,2)<>'24' and dbo.[invoice].[cust-no]<>'02000005' and dbo.[invoice].[cust-no]<>'02000031') or (dbo.[invoice-line].[db-id]='ri' and substring(dbo.invoice.[entity-code],2,3)='419' and substring(dbo.invoice.[entity-code],5,2)='23' and dbo.[invoice].[cust-no]<>'02000005' and dbo.[invoice].[cust-no]<>'02000031') then dbo.[invoice-line].[qty-shipped] else '0' end) as [华北],
sum(case when (dbo.[invoice-line].[db-id]='RCHQ' and substring(dbo.invoice.[entity-code],2,3)='119' and substring(dbo.invoice.[entity-code],5,2)<>'27' and substring(dbo.invoice.[entity-code],5,2)<>'24' and dbo.[invoice].[cust-no]<>'02000005' and dbo.[invoice].[cust-no]<>'02000031') or (dbo.[invoice-line].[db-id]='ri' and substring(dbo.invoice.[entity-code],2,3)='119' and substring(dbo.invoice.[entity-code],5,2)='23' and dbo.[invoice].[cust-no]<>'02000005' and dbo.[invoice].[cust-no]<>'02000031') then dbo.[invoice-line].[qty-shipped] else '0' end) as [华东],
sum(case when (dbo.[invoice-line].[db-id]='RCHQ' and substring(dbo.invoice.[entity-code],2,3)='219' and substring(dbo.invoice.[entity-code],5,2)<>'27' and substring(dbo.invoice.[entity-code],5,2)<>'24' and dbo.[invoice].[cust-no]<>'02000005' and dbo.[invoice].[cust-no]<>'02000031') or (dbo.[invoice-line].[db-id]='ri' and substring(dbo.invoice.[entity-code],2,3)='219' and substring(dbo.invoice.[entity-code],5,2)='23' and dbo.[invoice].[cust-no]<>'02000005' and dbo.[invoice].[cust-no]<>'02000031') then dbo.[invoice-line].[qty-shipped] else '0' end) as [华南],
[华北]+[华东]+[华南]