Question: what are sql analytic functions?
Answer: An analytic function computes values over a group of rows and returns a single result for each row. This is different from an aggregate function, which returns a single result for an entire group of rows. It includes an OVER clause, which defines a window of rows around the row being evaluated.