SELECT
borrow_no,
term_no,
sum( principal_amt ) over ( ORDER BY term_no DESC ) principal_amt
FROM
fas_user.T_BUSI_LOAN_REPAY_PLA
SELECT
borrow_no,
term_no,
sum( principal_amt ) over ( ORDER BY term_no DESC ) principal_amt
FROM
fas_user.T_BUSI_LOAN_REPAY_PLA