Order by must not be used on the first query whenever you are using except,intersect or minus query.

But you can use order by in the second query.Order by in the...