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

# Aggregate Functions

## `any_value`

*Supported Signatures*

```sql theme={null}
function any_value($1) returns $1
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#any_value)

## `array_agg`

*Supported Signatures*

```sql theme={null}
function array_agg($1) returns array<$1>
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#array_agg)

## `array_avg`

*Supported Signatures*

```sql theme={null}
function array_avg $1(array<$1>) returns double
	where $1 in (int, bigint, float, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#array_avg)

## `array_concat_agg`

*Supported Signatures*

```sql theme={null}
function array_concat_agg(array<$1>) returns array<$1>
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#array_concat_agg)

## `avg`

*Supported Signatures*

```sql theme={null}
function avg $1($1) returns $1
	where $1 in (double, interval)
function avg(bigint) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#avg)

## `bit_and`

*Supported Signatures*

```sql theme={null}
function bit_and(bigint) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#bit_and)

## `bit_or`

*Supported Signatures*

```sql theme={null}
function bit_or(bigint) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#bit_or)

## `bit_xor`

*Supported Signatures*

```sql theme={null}
function bit_xor(bigint) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#bit_xor)

## `corr`

*Supported Signatures*

```sql theme={null}
function corr(float64, float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#corr)

## `count`

*Supported Signatures*

```sql theme={null}
function count($1) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#count)

## `countif`

*Supported Signatures*

```sql theme={null}
function countif(bool) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#countif)

## `covar_pop`

*Supported Signatures*

```sql theme={null}
function covar_pop(float64, float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#covar_pop)

## `covar_samp`

*Supported Signatures*

```sql theme={null}
function covar_samp(float64, float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#covar_samp)

## `logical_and`

*Supported Signatures*

```sql theme={null}
function logical_and(bool) returns bool
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#logical_and)

## `logical_or`

*Supported Signatures*

```sql theme={null}
function logical_or(bool) returns bool
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#logical_or)

## `max`

*Supported Signatures*

```sql theme={null}
function max($1) returns $1
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#max)

## `max_by`

*Supported Signatures*

```sql theme={null}
function max_by($1, $2) returns $1
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#max_by)

## `min`

*Supported Signatures*

```sql theme={null}
function min($1) returns $1
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#min)

## `min_by`

*Supported Signatures*

```sql theme={null}
function min_by($1, $2) returns $1
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#min_by)

## `stddev_pop`

*Supported Signatures*

```sql theme={null}
function stddev_pop(float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#stddev_pop)

## `stddev_samp`

*Supported Signatures*

```sql theme={null}
function stddev_samp(float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#stddev_samp)

## `string_agg`

*Supported Signatures*

```sql theme={null}
function string_agg $1($1) returns $1
	where $1 in (string, bytes)
function string_agg $1($1, $1) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#string_agg)

## `sum`

*Supported Signatures*

```sql theme={null}
function sum($1) returns $1
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sum)

## `var_pop`

*Supported Signatures*

```sql theme={null}
function var_pop(float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#var_pop)

## `var_samp`

*Supported Signatures*

```sql theme={null}
function var_samp(float64) returns float64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#var_samp)