SQL SELECT COUNT, SUM, and AVG

For a list of all aggregate functions see our aggregate functions reference.

Get the total number of products.

SELECT COUNT(Id) AS 'Product Count'
  FROM Product

COUNT syntax.

SELECT COUNT(column-name)
  FROM table-name

SUM syntax.

SELECT SUM(column-name)
  FROM table-name

AVG syntax.

SELECT AVG(column-name)
  FROM table-name

SELECT COUNT(Id) AS 'Customer Count'
  FROM Customer

SELECT SUM(TotalAmount) AS 'Total Sales'
  FROM [Order]
 WHERE YEAR(OrderDate) = 2013

SELECT AVG(TotalAmount) AS 'Avg Order'
  FROM [Order]

• Our Sql COUNT Function Reference
• Our Sql SUM Function Reference
• Our Sql AVG Function Reference
• Our Sql Aggregate Functions Reference