This figure illustrates the processing order:

• Joins, WHERE, ORDER BY, and HAVING clauses

• Partitions created, analytic functions applied to each row in each partition

• Final ORDER BY