The following are various aggregate functions available:-

1. SUM

2. AVG

3. COUNT

4. COUNTDISTINCT

5. MAX

6. MIN

7. STDEV

8. STDEVP

9. VAR

10. VARP

By default, SUM is the aggregate function used for numeric data type.