Select SUPPORTER.ORG,SUM(CONTRIBUTION.AMOUNT),
CASE SUPPORTER.ORG
WHEN '1' THEN '단체'
WHEN '2' THEN '개인'
ELSE 'N/A' END
from CONTRIBUTION
INNER JOIN SUPPORTER
ON CONTRIBUTION.SUPPORTER_ID = SUPPORTER.SID
WHERE to_number(to_char(CONTRIBUTION_DATE,'YYYY')) = 2019
GROUP BY SUPPORTER.ORG
ORDER BY SUPPORTER.ORG