WITH STOCK_INFO AS (
    SELECT ITEM_CODE
          ,MAX(LAST_DELIVERY_DATE) AS LAST_DELIVERY_DATE
          ,SUM(ACTUAL_AMT) AS ACTUAL_AMT
         FROM STOCK
        GROUP BY ITEM_CODE
        ORDER BY ITEM_CODE
)
SELECT a.*
    FROM ITEM AS a
    JOIN STOCK_INFO AS b
    ON a.ITEM_CODE = b.ITEM_CODE
    WHERE LAST_DELIVERY_DATE >= DATE('2022-12-01') 
    AND ACTUAL_AMT >0
    AND STOCK_MANAGEMENT_TYPE = 1