-- select
--     *
-- from
--     stock
-- where
--     ("2023-01-01"<=last_delivery_date and last_delivery_date<="2023-01-31") and actual_amt=0;

delete
from
    stock
where
    ("2023-01-01"<=last_delivery_date and last_delivery_date<="2023-01-31") and actual_amt=0;

-- select
--     *
-- from
--     stock
-- where
--     ("2023-01-01"<=last_delivery_date and last_delivery_date<="2023-01-31") and actual_amt=0;