MIN, MAX, COUNT, AVG, SUM

MIN() 
Retrieves the smallest value for the selected column.
MAX() 
retrieves the largest value for the selected column.
COUNT() 
Gives total number of rows that matches the specified condition.
AVG() 
Gives the average for the specified numeric column.
SUM() 
Gives the total sum for the specified numeric column.

SYNTAX
SELECT min(column_name)
WHERE condition;  

EXAMPLE MIN
SELECT min(salary) 
FROM users 
WHERE Country='INDIA';  


SYNTAX
SELECT max(column_name)
WHERE condition;  

EXAMPLE MAX
SELECT max(salary) 
FROM users 
WHERE Country='INDIA';  
 
SYNTAX
SELECT count(column_name)
WHERE condition;  

EXAMPLE COUNT
SELECT count(name) 
FROM users 
WHERE Country='INDIA'; 

SYNTAX
SELECT sum(column_name)
WHERE condition;  

EXAMPLE SUM
SELECT sum(salary) 
FROM users 
WHERE Country='INDIA'; 

SYNTAX
SELECT AVG(column_name)
WHERE condition;  

EXAMPLE AVG
SELECT AVG(salary) 
FROM users 
WHERE Country='INDIA';