Basic aggregate functions   Following is the list of supported basic aggregate functions:

• SUM function [Aggregate]
• AVG function [Aggregate]
• MAX function [Aggregate]
• MIN function [Aggregate]
• MEDIAN function [Aggregate]
• FIRST_VALUE function [Aggregate]
• LAST_VALUE function [Aggregate]
• COUNT function [Aggregate]

Standard deviation and variance functions   Following is the list of supported standard deviation and variance functions:

• STDDEV function [Aggregate]
• STDDEV_POP function [Aggregate]
• STDDEV_SAMP function [Aggregate]
• VAR_POP function [Aggregate]
• VAR_SAMP function [Aggregate]
• VARIANCE function [Aggregate]

Correlation and linear regression functions   Following is the list of supported correlation and linear regression functions:

• COVAR_POP function [Aggregate]
• COVAR_SAMP function [Aggregate]
• REGR_AVGX function [Aggregate]
• REGR_AVGY function [Aggregate]
• REGR_COUNT function [Aggregate]
• REGR_INTERCEPT function [Aggregate]
• REGR_R2 function [Aggregate]
• REGR_SLOPE function [Aggregate]
• REGR_SXX function [Aggregate]
• REGR_SXY function [Aggregate]
• REGR_SYY function [Aggregate]