WITH tmp AS(
    SELECT *
    FROM STOCK
    WHERE DATE(LAST_DELIVERY_DATE) BETWEEN "2023-01-01" AND "2023-01-31"
    AND ACTUAL_AMT=0
)

SELECT *
FROM STOCK
LEFT JOIN tmp 
WHERE tmp.WH_CODE IS NULL;