count(*), sum, avg, max, min ex: select count(*), sum(balance) from customer;
takes values of that attribute in the set of returned rows and computer a single value  ex: count()  sum()  avg()  min()  max()
Appellate courts across the country have issued differing rulings on the issue , allowing public displays of the Ten Commandments in some cases and banning them in others .