# SQL COUNT(), AVG() and SUM() Functions

The COUNT() function returns the number of rows that matches a specified criteria.

The AVG() function returns the average value of a numeric column.

The SUM() function returns the total sum of a numeric column.

#### COUNT() Syntax

```sql
SELECT COUNT(column_name)
FROM table_name
WHERE condition;
```

#### AVG() Syntax

```sql
SELECT AVG(column_name)
FROM table_name
WHERE conditionSUM() Syntax
```

> #### SUM() Syntax

```sql
SELECT SUM(column_name)
FROM table_name
WHERE condition;
```

### Demo Database

 Below is a selection from the "Products" table in the Northwind sample database

![](https://826093633-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LS8lPNzCGPR5-DLbGXv%2F-LST9Ou2u55zTiUeQtOI%2F-LSTBsnZBb20AfBHg762%2Fimage.png?alt=media\&token=5d02fb11-b5a3-4794-b5d9-f97d208fc282)

### SUM() 

The following SQL statement finds the sum of the "Quantity" fields in the "OrderDetails" table:<br>

```sql
SELECT SUM(Quantity)
FROM OrderDetails;
```