sql case when

  SELECT T1.LA,T1.NCS_CASE_COUNT,T1.NCS_PAYMENT,T2.RCS_CASE_COUNT,
  T2.RCS_PAYMENT_AMOUNT,T1.NCS_CASE_COUNT-T2.RCS_CASE_COUNT,
  T1.NCS_PAYMENT-T2.RCS_PAYMENT_AMOUNT FROM
 (
  SELECT lanewicno as la,count(*) as ncs_case_count,SUM(payment_amount) as ncs_payment FROM
  (
  SELECT CC.CLAIMNO,SUM(NVL(PAYAMT,0)) AS PAYMENT_AMOUNT,
  (CASE WHEN TRIM(A.LANEWICNO) IS NOT NULL THEN TRIM(A.LANEWICNO)||'NIC'
                                      WHEN TRIM(A.LAICNO) IS NOT NULL THEN TRIM(A.LAICNO)||'OIC'
                                      ELSE '' END ) as lanewicno
  FROM MSCLMREG A,MSCLMPOLCC CC WHERE A.CLAIMNO = CC.CLAIMNO
  GROUP BY CC.CLAIMNO,A.lanewicno,a.LAICNO) GROUP BY LANEWICNO
)T1, 
( 
  SELECT LANUM AS LA_NUM,
        COUNT(1) AS RCS_CASE_COUNT,
        sum(TOTPAYAMT) as RCS_payment_amount
    from CCCBSC
    WHERE PRCESTATUS = 'End' AND EVLSTATUS <> 'REJ'
     -- AND CSCLMTYPE <> 'DIS'
    GROUP BY LANUM
) t2 where t1.la = t2.LA_NUM