Add support for unsupported Aggregate and Analytic functions

[AnastasiiaSergienko]

Aggregate Functions

Unsupported

• GROUPING[_ID]
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/grouping[_id].htm

• PERCENTILE_CONT
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_cont.htm

• PERCENTILE_DISC
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_disc.htm

Partly supported without keywords and OVER clause

• AVG
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/avg.htm

• CORR
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/corr.htm

• COUNT
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/count.htm

• COVAR_POP
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/covar_pop.htm

• COVAR_SAMP
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/covar_samp.htm

• FIRST_VALUE
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/first_value.htm

• GROUP_CONCAT
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/group_concat.htm

• LAST_VALUE
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/last_value.htm

• MAX
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/max.htm

• MEDIAN
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/median.htm

• MIN
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/min.htm

• REGR_FUNCTIONS
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/regr_function.htm

• STDDEV
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/stddev.htm

• STDDEV_POP
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/stddev_pop.htm

• STDDEV_SAMP
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/stddev_samp.htm

• SUM
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/sum.htm

• VAR_POP
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/var_pop.htm

• VAR_SAMP
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/var_samp.htm

• VARIANCE
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/variance.htm

Analytic Functions

Unsupported

• CUME_DIST
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/cume_dist.htm

• DENSE_RANK
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/dense_rank.htm

• LAG
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/lag.htm

• LEAD
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/lead.htm

• NTH_VALUE
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/nth_value.htm

• NTILE
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/ntile.htm

• PERCENT_RANK
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percent_rank.htm

• PERCENTILE_CONT
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_cont.htm

• PERCENTILE_DISC
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/percentile_disc.htm

• RANK
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/rank.htm

• RATIO_TO_REPORT
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/ratio_to_report.htm

• ROW_NUMBER
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/row_number.htm

Partly supported without keywords and OVER clause

• ANY
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/any.htm

• EVERY
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/every.htm

• LISTAGG
  https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/listagg.htm

Other

• NAMED WINDOW CLAUSE
  https://docs.exasol.com/sql_references/functions/analyticfunctions.htm#microcontent5
• over_clause
  https://docs.exasol.com/sql_references/functions/analyticfunctions.htm?Highlight=over_clause