7. What basic analytical functions are defined in SQL?
The basic ones include simple statistical functions: SUM, AVERAGE, standard deviation, and variance. The newer ones include correlation and bivariate regression. The new ranking functions (RANK, DENSE_RANK, PERCENT_RANK, and CUME_DIST) will be useful when vendors implement them.