In previous lessons, we have learnt about numbers. Here we are going to do something complex and different with these numbers. We will make counting, summing up of different numbers and will get their average.
AVG: It gets average of the whole column.
COUNT: It shows the total amount of records.
MAX: We get to know about the maximum of a specific column.
MIN: It tells us about minimum of a specific column.
SUM: It gives the whole sum of the given numbers.
The structure for such type of functions is given below:
Besides these arithmetical functions, we can also do subtraction and addition. Concatenation, sub string and trim are the functions, which are used for data which is character type. In order to see the working of such functions, it is better to get a view of their references.