COUNT, SUM, MIN, MAX, AVG Functions

SQL provides built-in aggregate functions that let you perform calculations on data in a column — like counting rows or finding the highest value.

Common Aggregate Functions

• COUNT(*) counts the total number of rows
  

SELECT COUNT(*) FROM students;

• SUM(column) adds up all the values in a column
  

SELECT SUM(age) FROM students;

• MIN(column) returns the smallest value
  

SELECT MIN(age) FROM students;

• MAX(column) returns the largest value
  

SELECT MAX(age) FROM students;

• AVG(column) calculates the average value
  

SELECT AVG(age) FROM students;

These functions are useful when you want summary statistics from your data — like total users, average age, or highest score.

‍