---
schema_version: "1"
id: b82c6bfb8d73fddb9555622e04cacb20cc93f006996b986ebd44f2369a88c167
title: AVG
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/aggregate-func/avg.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/avg.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: f59a1236625959e5e91646bba788c5df6086ab91401658f0a71f9fcdb7dc5a83
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `AVG`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the average (arithmetic mean) of all input values.

## Syntax

```sql
avg(<expression>)
```

## Arguments

### Required

- `<expression>`: An expression of any numerical type.

## Returns

- `numeric` with a scale of 6 for integer-type arguments and numeric arguments with a scale less than 6.
- `double precision` for floating-point arguments.
- Otherwise, returns the same as argument the type.

Returns NULL if no rows are selected.

## Considerations

- NULL values are ignored in the calculation.
- Returns NULL when applied to an empty set.
- Use `COALESCE` to substitute a default value for NULL results.

## Examples

### Calculate Average

Get the average price of products.

```sql
SELECT avg(price) AS average_price
FROM products;
```

### Average by Group

Calculate the average salary by department.

```sql
SELECT department, avg(salary) AS avg_salary
FROM employees
GROUP BY department;
```

### Handle Empty Results

Use COALESCE to handle NULL results.

```sql
SELECT coalesce(avg(quantity), 0) AS avg_quantity
FROM orders
WHERE order_date > '2024-01-01';
```

## Related Documentation

- [SUM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/sum.md)
- [COUNT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/count.md)
- [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.md)