This is less a coding/querying question and more a logic/mathematics question.
I cannot for the life of me understand why a “low” ratio = more reorders, and a “high” ration = more first purchases when reorder_rate = distinct order_ids / distinct delivered_to (i.e. reorder_rate = number of times an item was ordered / number of people it was delivered to).
I understand the code needed to obtain the correct answers; just don’t understand the actual logic behind the calculation. It seems backwards to me; I’d expect “high” ratios to mean more reorders, and “low” ratios to mean less reorders.
Can someone please shed some light? This has been driving me mad for two days.