Aggregation Functions

[jexp]

There seems to be a lot of useful aggregation functions that we don’t cover yet

https://duckdb.org/docs/sql/aggregates

---

Created a google sheet report.

Here is the missing agg. functions:

• any_value(arg)
• bit_and(arg)
• bit_or(arg)
• bit_xor(arg)
• bool_and(arg)
• bool_or(arg)
• geomean(arg)
• approx_count_distinct(x)
• approx_quantile(x, pos)
• reservoir_quantile(x, quantile, sample_size=8192)
• corr(y, x)corr(y, x)
• covar_pop(y, x)
• covar_samp(y, x)
• entropy(x)
• kurtosis(x)
• mad(x)
• mode(x)
• regr_avgx(y, x)
• regr_avgy(y, x)
• regr_r2(y, x)
• regr_slope(y, x)
• regr_sxx(y, x)
• regr_sxy(y, x)
• regr_syy(y, x)
• skewness(x)
• var_pop(x)
• mode()