Aggregate Function Computation Find the average account balance at the perryridge branch select avg(balance) from account where branch-name="Perryridge Balances of perryridge accounts account select balance from account where branch-name AvgO Perryridge 120.000 COMP3311 Fall 2011 CSE, HKUST Slide 12COMP3311 Fall 2011 CSE, HKUST Slide 12 Aggregate Function Computation • Find the average account balance at the Perryridge branch. select avg(balance) from account where branch-name=“Perryridge” account select balance from account where branch-name =“Perryridge” Avg() 120,000 Balances of Perryridge accounts