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

From ZCubes Wiki
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;