SELECT USERNAME,ORDER_CODE,MAX(DATE) AS ULTIMO_PAGAMENTO
FROM ACCOUNT
INNER JOIN FATTURE ON ACCOUNT.ID = FATTURE.FK
GROUP BY USERNAME, ORDER_CODE

Almeno credo...