aggregate function nothing but group fuction.
there are max, min, avg,sum, count, stddev, variance