Example 2 - MIN(), MAX(), AVG(), SUM()

This video segment describes the MIN, MAX and ABG() functions. I include the SUM() function again so we can generate a nice profile report of the data in our example. The MIN function will return the smallest value in a column within a partition while the MAX function returns the largest. The AVG() function is used to calculate averages of the values within the partition. Recall that the SUM() function is used to calculate the totals of values in a column within the partition.