> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Aggregate

> Aggregate functions operate on values across rows to make calculations such as sum, average, minimum/maximum, and count. These functions take 0 or more rows and produce a single output.

## COUNT

Returns the number of rows that match the query criteria.

```sql theme={null}
SELECT COUNT(*) FROM Account WHERE Industry = 'Floppy Disks'
```

## COUNT(DISTINCT)

Returns the number of distinct, non-null field values that match the query criteria.

```sql theme={null}
SELECT COUNT(DISTINCT BillingState) AS DistinctValues FROM Account WHERE Industry = 'Floppy Disks'
```

## AVG

Returns the average of the column values.

```sql theme={null}
SELECT Name, AVG(AnnualRevenue) FROM Account WHERE Industry = 'Floppy Disks'  GROUP BY Name
```

## MIN

Returns the minimum column value.

```sql theme={null}
SELECT MIN(AnnualRevenue), Name FROM Account WHERE Industry = 'Floppy Disks' GROUP BY Name
```

## MAX

Returns the maximum column value.

```sql theme={null}
SELECT Name, MAX(AnnualRevenue) FROM Account WHERE Industry = 'Floppy Disks' GROUP BY Name
```

## SUM

Returns the total sum of the column values.

```sql theme={null}
SELECT SUM(AnnualRevenue) FROM Account WHERE Industry = 'Floppy Disks'
```