SELECT UPPER(A.SUP_NAME) AS NCC, UPPER(A.TAX_NO) AS TAX, UPPER(A.CONTACT_PERSON) AS NDD, UPPER(A.TEL) AS TEL, UPPER(A.EMAIL) AS EMAIL, SUM(B.TOTAL_AMT) AS DOANH_SO_2024
FROM CM_SUPPLIER A
INNER JOIN TR_REQUEST_DOC_DT B ON A.SUP_ID = B.SUP_ID
INNER JOIN TR_REQUEST_DOC C ON B.REQ_DOC_ID = C.REQ_ID
WHERE C.PROCESS_ID ='APPROVE' AND YEAR(C.CREATE_DT) =2024 AND C.BRANCH_CREATE ='DV0001'
GROUP BY A.SUP_NAME,A.TAX_NO,A.CONTACT_PERSON, A.TEL, A.EMAIL