>SELECT SUM(nloan_amount) as Total_Amt_CAP_Loans FROM loan.dbf WHERE UPPER(cstatus) = "ENROLLED" OR UPPER(cstatus) = "LOSS" OR UPPER(cstatus) = "PIF" > >SELECT SUM(nloan_amount) as Total_Amt_Enrolled_Loans FROM loan.dbf WHERE UPPER(cstatus) = "ENROLLED" > >SELECT SUM(nstate_reserve_payment) as nBDC_Reserve FROM loan.dbf WHERE UPPER(cstatus) = "ENROLLED" OR UPPER(cstatus) = "LOSS" OR UPPER(cstatus) = "PIF" > >SELECT SUM(nborrower_reserve_payment) + SUM(nlender_reserve_payment) as nBank_Borrower_Reserve FROM loan.dbf WHERE UPPER(cstatus) = "ENROLLED" OR UPPER(cstatus) = "LOSS" OR UPPER(cstatus) = "PIF" > >SELECT SUM(ytotal_claim_amount) as nClaims_Paid FROM claims.dbf >
SELECT SUM(IIF(UPPER(cstatus)="ENROLLED",1,0)*nloan_amount) as Total_Amt_Enrolled_Loans, ; SUM(nloan_amount) as Total_Amt_CAP_Loans,SUM(nstate_reserve_payment) as nBDC_Reserve, ; SUM(nborrower_reserve_payment+nlender_reserve_payment) as nBank_Borrower_Reserve, ; (SELECT SUM(ytotal_claim_amount) FROM claims) as nClaims_Paid ; FROM loan WHERE INLIST(UPPER(cstatus),"ENROLLED","LOSS","PIF")