Question

explain the following functions :-
1st ) SUM ()
2nd) AVERAGE ()
3rd) MAX()
4th) MIN ()

plz plz can you answer me the questions which i gave plz plz i have exam on evening so plz plz ​

Answer 1

Answer:

sum means to add

average means to find that phone different numbers who is the the biggest one

Answer 2

Answer:

MIN function

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

As an example, let's suppose we want to know the year in which the oldest movie in our library was released, we can use MySQL's MIN function to get the desired information.

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.

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.

Let's assume we want to get the year that the latest movie in our database was released. We can easily use the MAX function to achieve that.