The image shows SQL Analytic Functions Available Across all Data (data in the database and in the data lake).

This image shows four boxes: Advanced Statistics, Common Analytics, JSON Functions, and Advanced Analytics.

Advanced Statistics includes: Statistical aggregates, linear regression, descriptive stats, correlations, cross tabs, hypothesis testing, distribution fitting, and pareto analysis.

Common Analytics includes: Window functions, ranking, lag/lead, top-N, WITH clause, Pivot/Unpivot, aggregation functions, approximate queries, ration to report.

JSON Functions includes: JSON Functions, JSON table, JSON Object, JSON Query.

Advanced Analytics includes: analytics, pattern matching, and model clause.