In a distributed query execution system, ORDER BY in the middle of the query are meaningless so we should drop it.