I have looked at the query until I am now blue in the face.

It just doesn't seem plausible that a customer can be both active and dormant, yet in this query, there are customers considered dormant who are active and just purchased last week.