--October 29, 2009 Aggregate Examples

set echo on

--count

SELECT count (branch_name) from branch; 

SELECT count (branch_name) from loan; 

SELECT count (branch_name) from account; 

select count (distinct branch_name) from account;

--max/min

SELECT max (balance) from account; 

SELECT min (balance) from account; 

SELECT avg (balance) from account;