Yurttas/PL/DBL/oracle/F/01/Bank/a01.sql
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;
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;