First of all we should know that logical and physical order of query execution are different but result must be the same.