# Aggregate functions
<a name="sql-functions-agg-spark"></a>

Aggregate functions in AWS Clean Rooms Spark SQL are used to perform calculations or operations on a group of rows and return a single value. They are essential for data analysis and summarization tasks.

AWS Clean Rooms Spark SQL supports the following aggregate functions:

**Topics**
+ [ANY\_VALUE function](ANY_VALUE.md)
+ [APPROX COUNT\_DISTINCT function](approx-count-distinct.md)
+ [APPROX PERCENTILE function](approx-percentile.md)
+ [AVG function](avg-function.md)
+ [BOOL\_AND function](BOOL_AND.md)
+ [BOOL\_OR function](BOOL_OR.md)
+ [CARDINALITY function](CARDINALITY.md)
+ [COLLECT\_LIST function](COLLECT_LIST.md)
+ [COLLECT\_SET function](COLLECT_SET.md)
+ [COUNT and COUNT DISTINCT functions](count-function.md)
+ [COUNT function](COUNT.md)
+ [MAX function](MAX.md)
+ [MEDIAN function](MEDIAN.md)
+ [MIN function](MIN.md)
+ [PERCENTILE function](percentile.md)
+ [SKEWNESS function](SKEWNESS.md)
+ [STDDEV\_SAMP and STDDEV\_POP functions](STDDEV_functions.md)
+ [SUM and SUM DISTINCT functions](sum-function.md)
+ [VAR\_SAMP and VAR\_POP functions](VARIANCE_functions.md)