Ok so I have recipient, deliveries and orders. 1 recipient can have X deliveries and Y orders. 1 delivery can have Z recipient. 1 order can have 1 recipient.
I am trying to find the number of orders recipients have made in the 7days following the sent of a delivery. But not for one delivery in particular. I would like to have for all deliveries of the year, the sum of orders in the following 7days.