Yurttas/PL/DBL/mssql/F/01/Bank/a01.sql
Jump to navigation
Jump to search
1/*
2REM
3REM a01.sql
4REM
5REM Find the average account balance at each branch.
6REM
7*/
8
9SELECT branchname, AVG(balance)
10FROM Depositor
11GROUP BY branchname;