Aggregate Functions

• MIN()

• MAX()

• COUNT()

• SUM()

• AVG()

SELECT MAX(`column_name`) FROM `table_name`;
SELECT MIN(`column_name`) FROM `table_name`;
SELECT COUNT(`column_name`) FROM `table_name`;
SELECT SUM(`column_name`) FROM `table_name`;
SELECT AVG(`column_name`) FROM `table_name`;