Order of operation

1. Sub-queries
2. Joins (including join conditions in the WHERE clause)
3. PIVOT and UNPIVOT
4. START WITH and CONNECT BY clauses
5. WHERE clause
6. GROUP BY clause and aggregate functions
7. HAVING clause
8. Analytic functions (such as RANK)
9. ORDER BY clause

https://forums.oracle.com/ords/apexds/post/what-is-the-order-of-operations-3634

Order of logical operation

1. Not
2. And
3. Or