《Database System Concepts Course Introduction》ch03.pptVIP

Aggregate Functions – Group By Find the number of depositors for each branch. Note: Attributes in select clause outside of aggregate functions must appear in group by list count (distinct *) is false select branch_name, count (distinct customer_name) from depositor, account where depositor.account_number = account.account_number group by branch_name Aggregate Functions – Having Clause Find the names of all branches where the average account balance is more than $1,200. Note: predicates in the having clause are applied after the formation of groups