I think the discrepancy results from two different viewpoints.
There are quite a few sources on the web which support your "Order of SQL execution". However, these texts were written to give a human developer, trying to write or understand SQL, a conceptual guide on how to his query is going to...