AVG, LEAD, and PERCENTILE RANK are examples of analytical functions. PARTITION BY job or PARTITION BY dept, for example, is a partitioning clause. Order by clauses, such as order by job nulls, come last. RANGE UNBOUNDED PRECEDING or ROWS UNBOUNDED FOLLOWING are examples of windowing clauses.