select DTID from DEDUCTION_TYPE
WHERE ACTIVE = 'A'
ORDER BY DTID
WHERE TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'YYYY')) = 2020
AND UPPER(MISSIONARY_ID) = 'A02'
GROUP BY DEDUCTION
Select TOTAL,DEDUCTION , d.DTYPE, d.DTPERCENT from (select SUM(AMOUNT) as "TOTAL",DEDUCTION from contribution c
WHERE TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'YYYY')) = 2020 AND TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'MM')) = 2
-- AND UPPER(MISSIONARY_ID) = 'A02'
GROUP BY DEDUCTION )
INNER JOIN DEDUCTION_TYPE d
ON d.DTID = DEDUCTION
ORDER BY DEDUCTION