The following code selects the largest order (or, in the case of a tie, orders) from each customer.

WITH

Step1 as (

SELECT

...