select 'A' supplier, 'shirt' product, 5 quantity, STR_TO_DATE('01/01/2019', '%m/%d/%Y') DateInserted

union all

select 'B' supplier, 'shirt' product, 5 quantity, STR_TO_DATE('01/29/2019', '%m/%d/%Y') DateInserted

union all

select 'C' supplier, 'shirt' product, 10 quantity, STR_TO_DATE('01/30/2019', '%m/%d/%Y') DateInserted

)

select * from(

select Supplier, Product, DateInserted, Quantity OldQuantity

,case when cumulsum <= TotalRequiredQuantity then 0 else cumulsum-TotalRequiredQuantity end NewQuantity

from(

select *, 7 TotalRequiredQuantity,

sum(quantity) over(partition by Product order by DateInserted ) cumulsum

from cte

)q

)q1

where OldQuantity>=NewQuantity;