SQL Order Of Operations

For SQL select statements, with only one select operation, the order of operations is: from, join, where, group by, having, select, distinct, order by and limit.

Note that on clauses are parts of join operations, and, window functions are parts of select operations.  Note also that where operations must appear after join operations and before group by operations.