Yurttas/PL/DBL/mysql/F/01/00/bank/BankTwo/a03.sql
Jump to navigation
Jump to search
1/*
2REM
3REM a03.sql
4REM
5REM Find the average account balance at each branch
6REM where the average account balance is more than $400.
7REM
8*/
9
10\. set-db.sql
11
12SELECT branchname, AVG(balance)
13FROM Depositor
14GROUP BY branchname
15HAVING AVG(balance)>400;