We sell fashion. I was reading this. Now how do I get a list of all customers who bought a size S shirts? (filter on size S).
Size is the attribute to define the simple product from configurable. In addition there may me weird cases where a customer ordered both 43 and 44 size, bit 44 size more often, so this is why we are suggesting to using a max to identify a customers favorite size
Question: How can we identify a customers favorite size using a query?