Built-In Functions:

Aggregate Functions:

Avg: Calculates the average of given set of values.

Ex: Avg (Emp.SAL)                                         >> 50

Count: Counts the number of values in a table column

Ex: Count (Emp.EID)                                      >> 5

Count_Distinct: counts the number of distinct non null values in a table column.

Ex: Count_Distinct (Emp.Ename)                    >> 4

Min: Returns the minimum value from list

Ex: Min (Emp.SAL)                                         >> 20

Max: Returns the maximum value from list

Ex: Max (Emp.SAL)                                        >>90

Sum: Calculates the sum of given set of values

Ex: Sum (Emp.SAL)                                        >> 250