Orders by delivery sent



Hi there,

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.

Someone can help me with this ?

Thanks a lot !


Accepted Solutions (0)

Answers (0)