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

# Overview

Aggregate functions compute a single result from a set of input values. Oxla supports the following functions:

| **Function Name**                                                      | **Description**                                                                                                                 |
| ---------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| [SUM](/sql-reference/sql-functions/aggregate-functions/sum)            | Calculates and returns the sum of all values                                                                                    |
| [MIN](/sql-reference/sql-functions/aggregate-functions/min)            | Calculates and returns the minimum value                                                                                        |
| [FOR\_MIN](/sql-reference/sql-functions/aggregate-functions/for-min)   | Calculates and returns a value corresponding to the minimal metric in the same row from a set of values                         |
| [MAX](/sql-reference/sql-functions/aggregate-functions/max)            | Calculates and returns the maximum value                                                                                        |
| [FOR\_MAX](/sql-reference/sql-functions/aggregate-functions/for-max)   | Calculates and Returns a value corresponding to the maximum metric in the same row from a set of values                         |
| [AVG](/sql-reference/sql-functions/aggregate-functions/avg)            | Calculates and returns the average value                                                                                        |
| [COUNT](/sql-reference/sql-functions/aggregate-functions/count)        | Counts the number of rows                                                                                                       |
| [BOOL\_AND](/sql-reference/sql-functions/aggregate-functions/bool-and) | Calculates the boolean of all the boolean values in the aggregated group. `FALSE` if at least one of aggregated rows is `FALSE` |
| [BOOL\_OR](/sql-reference/sql-functions/aggregate-functions/bool-or)   | Calculates the boolean of all the boolean values in the aggregated group. `TRUE` if at least one of aggregated rows is `TRUE`   |

| **Function qualifier**                                                | **Description**                                                                     |
| --------------------------------------------------------------------- | ----------------------------------------------------------------------------------- |
| [DISTINCT](/sql-reference/sql-functions/aggregate-functions/distinct) | Allows aggregation functions to operate on a distinct set of values within a column |

<Check>You can utilize the aggregate functions with the `GROUP BY` and `HAVING` clauses in the `SELECT` statement.</Check>