I like the question and the order by concern has already been pointed out. The part of the explanation that really bothers me is this: "It is recommended...
I think there is a typo in Listing 1 - the subquery in the column list is counting the total orders which have a 'ModifiedDate' of 2007-02-19. Should this...