COUNT, SUM, AVG, MIN and MAX

COUNT()

SELECT COUNT(*) FROM students;            -- all rows
SELECT COUNT(phone) FROM students;       -- non-NULL phones
SELECT COUNT(DISTINCT class) FROM students; -- unique classes

SUM, AVG, MAX, MIN

SELECT SUM(amount) AS total_fee FROM fees;
SELECT AVG(marks) AS avg_marks FROM students;
SELECT MAX(marks) AS topper FROM students;
SELECT MIN(marks) AS lowest FROM students;

Important

Summary

• COUNT(*) = all rows; COUNT(col) skips NULLs; COUNT(DISTINCT col) = unique.
• SUM/AVG for numbers, MAX/MIN for highest/lowest.

COUNT()

SELECT COUNT(*) FROM students;            -- सारी rows
SELECT COUNT(phone) FROM students;       -- non-NULL phones
SELECT COUNT(DISTINCT class) FROM students; -- unique classes

SUM, AVG, MAX, MIN

SELECT SUM(amount) AS total_fee FROM fees;
SELECT AVG(marks) AS avg_marks FROM students;
SELECT MAX(marks) AS topper FROM students;
SELECT MIN(marks) AS lowest FROM students;

महत्वपूर्ण

सारांश

• COUNT(*) = सारी rows; COUNT(col) NULLs छोड़ता है; COUNT(DISTINCT col) = unique।
• SUM/AVG numbers के लिए, MAX/MIN highest/lowest के लिए।