SELECT CUSTOMERS.CUSTOMER_ID,CUSTOMERS.FIRST_NAME,CUSTOMERS.LAST_NAME,
SUM(PAYMENTS.PAID_AMOUNT) as TOTAL_PAYMENT, PAYMENTS.[TYPE]
FROM PAYMENTS
INNER JOIN CUSTOMERS ON PAYMENTS.CUSTOMER_ID=CUSTOMERS.CUSTOMER_ID
GROUP BY CUSTOMERS.CUSTOMER_ID,CUSTOMERS.FIRST_NAME,CUSTOMERS.LAST_NAME,
PAYMENTS.PAID_AMOUNT, PAYMENTS.[TYPE];