Classify Customer Order Method Preference Based On Their History?

I am trying to classify a customer's order method preference based on their history. My source table has every order, order method, date, etc.

The logic is:

If only one order method, that is their preference>1 order method, the majority is their preferenceif 50/50 split, the order method with the mose recent order is the preference

I then created a query to group by the customer, order method, and max(date):

[URL]

I am having trouble though, creating a query that applies the above logic and outputs this:[URL]