AVG Example:
| CONTRACT_ID | AMOUNT |
|---|---|
| 1 | 400 |
| 2 | 500 |
| 3 | 700 |
SELECT AVG(c.amount) AS AverageAmount
FROM contracts c
WHERE c.amount > 400 ;
| AverageAmount |
|---|
| 600 |
See also: T-SQL Functions -> Count -> Max -> Min -> Sum
| CONTRACT_ID | AMOUNT |
|---|---|
| 1 | 400 |
| 2 | 500 |
| 3 | 700 |
SELECT AVG(c.amount) AS AverageAmount
FROM contracts c
WHERE c.amount > 400 ;
| AverageAmount |
|---|
| 600 |
See also: T-SQL Functions -> Count -> Max -> Min -> Sum