compile sql server online

Language: Layout:

--Title of this code
--Sql Server 2012 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

create table Test 
( 
  EXIST_IN_New varchar(20),
  EXIST_IN_Old varchar(20),
  Old_Type_1 int,
  Old_Type_2 int,
  New_Type_1 int,
  New_Type_2 int,
  Comments    varchar(20)
  )
  insert into Test values
  ( 'Exists','Exists',3,2,2,2,'Exists in both'),
  ( 'Exists','Exists',5,2,4,3,'Exists in both'),
  ( 'Not Exists','Exists',3,2,0,0,'Exists only in old'),
  ( 'Exists','Not Exists',0,0,4,3,'Exists only in new')
    
 
 
 select PaymentType,
[Exists only in old],
diff,
[Exists only in New],
([Exists only in old]+diff+[Exists only in New]) as Total
from
(
-- Fetch Data for Type 1
select 'Type1' as PaymentType,
       sum( case when EXIST_IN_New = 'Not Exists' and EXIST_IN_Old='Exists' 
            then Old_Type_1
            else 0 end) as 'Exists only in old',
       sum( case when EXIST_IN_New = 'Exists' and EXIST_IN_Old='Not Exists' 
            then New_Type_1
            else 0 end) as 'Exists only in New',
       sum( case when EXIST_IN_New = 'Exists' and EXIST_IN_Old='Exists' 
            then Old_Type_1
            else 0 end) - 
         sum( case when EXIST_IN_New = 'Exists' and EXIST_IN_Old='Exists' 
            then New_Type_1
            else 0 end)   as diff                  
from 
Test
union
-- Fetch Data for Type 2
select 'Type2' as PaymentType,
       sum( case when EXIST_IN_New = 'Not Exists' and EXIST_IN_Old='Exists' 
            then Old_Type_2
            else 0 end) ,
       sum( case when EXIST_IN_New = 'Exists' and EXIST_IN_Old='Not Exists' 
            then New_Type_2
            else 0 end) ,
       sum( case when EXIST_IN_New = 'Exists' and EXIST_IN_Old='Exists' 
            then Old_Type_2
            else 0 end) - 
         sum( case when EXIST_IN_New = 'Exists' and EXIST_IN_Old='Exists' 
            then New_Type_2
            else 0 end)                   
from 
Test
)as T

View schema
Execution time: 0.11 sec, rows selected: 3, rows affected: 4, absolute service time: 0.23 sec