To solve this, as far as I can see, we need to using windowing functions, which rely on an ORDER BY clause.  My question is: if there's a tie on CompletedDate, what column do we then order on?  If it's Status, what is the order of priority of the different statuses?

John