The SQL COUNT, AVG And SUM - SQL Learn

THE SQL COUNT(), AVG() AND SUM()


Count() :

SELECT COUNT(column_name)

FROM table_name

WHERE condition;


Avg() :

SELECT AVG(column_name)

FROM table_name

WHERE condition;


Sum() :

SELECT SUM(column_name)

FROM table_name

WHERE condition;


DEMO DATABASE

ProductID ProductName SupplierID CategoryID Unit Price
1 Chais 1 1 10 boxes x 20 bags 18
2 Chang 1 1 24 - 12 oz bottles 19
3 Aniseed Syrup 1 2 12 - 550 ml bottles 10
4 Chef Anton's Cajun Seasoning 2 2 48 - 6 oz jars 22
5 Chef Anton's Gumbo Mix 2 2 36 boxes 21.35


>_ Sekian kalo ada yang salah mohon dikoreksi

أحدث أقدم