Yurttas/PL/DBL/oracle/F/01/Bank/a03.sql
Jump to navigation
Jump to search
1REM
2REM a03.sql
3REM
4REM Find the average account balance at each branch where the average
5REM account balance is more than $200.
6REM
7
8SELECT branchname, AVG(balance)
9FROM Depositor
10GROUP BY branchname
11HAVING AVG(balance)>200;