Yurttas/PL/DBL/oracle/F/01/Bank/a01.sql

From ZCubes Wiki
Jump to navigation Jump to search
1REM
2REM a01.sql
3REM
4REM Find the average account balance at each branch.
5REM
6
7SELECT branchname, AVG(balance)
8FROM Depositor
9GROUP BY branchname;