Historic Forward Sales

[Rust]

Hello,

I'm trying to create a straight table to show me historic forward sales.

I want to see the sum of Sales_QTY where the Order_Date is before a date and the Shipping_Date is after the date.

Example: If the Order_Date is 2022-01-01 I want to sum all Sales_QTY where the Order_Date is smaller than 2022-01-01 and Shipping_Date is greater than 2022-01-01.

DataSet:

Order_ID	Order_Date	Shipping_Date	Sales_QTY
12345	2022-01-01	2022-01-02	12
12346	2022-01-01	2022-01-05	15
12347	2022-01-03	2022-01-06	24
12348	2022-01-03	2022-01-09	14
12349	2022-01-05	2022-01-06	3
12350	2022-01-05	2022-01-08	6
12351	2022-01-07	2022-01-07	14
12352	2022-01-07	2022-01-10	8
12353	2022-01-09	2022-01-11	15
12354	2022-01-09	2022-01-10	7
12355	2022-01-09	2022-01-14	6

Desired Result: 

Order_Date	Sales_QTY
2022-01-01	0
2022-01-03	15
2022-01-05	38
2022-01-07	20
2022-01-09	8