Question

Define the given functions with syntax: (a) SUM (b) AVERAGE (c)COUNT (d) MAX (e)MIN​

Answer 1

Explanation:

(SUM function)

Suppose we want a report that gives total amount of payments made so far. We can use the MySQL SUM function which returns the sum of all the values in the specified column. SUM works on numeric fields only. Null values are excluded from the result returned.

(AVG function)

MySQL AVG function returns the average of the values in a specified column. Just like the SUM function, it works only on numeric data types.

(COUNT Function)

The COUNT function returns the total number of values in the specified field. It works on both numeric and non-numeric data types. All aggregate functions by default exclude nulls values before working on the data.

(MAX function)

Just as the name suggests, the MAX function is the opposite of the MIN function. It returns the largest value from the specified table field.

(MIN function)

The MIN function returns the smallest value in the specified table field.