Anonymous

SELECT b.bra_code, b.bra_location, at.acctyp_code, at.acctyp_desc, SUM(a.accnt_bal) AS "Total Current Value"
FROM BRANCH b, ACCTYPE at, CUSTOMER c, ACCOUNT a
WHERE c.cust_no = a.cust_no
  AND c.bra_code = b.bra_code
  AND at.acctyp_code = a.acctyp_code
GROUP BY b.bra_code, b.bra_location, at.acctyp_code, at.acctyp_desc
ORDER BY b.bra_code;