SELECT
    ORDERS_DTL.ITEM_CODE AS 'CODE',
    ITEM_NAME AS 'NAME',
    COUNT(ITEM.ITEM_CODE) AS 'SUM_QTY'
FROM ORDERS_DTL
WHERE ORDERS_DTL.ORDER_NO = ANY(SELECT ORDERS.ORDER_NO
                                FROM ORDERS
                                JOIN WAREHOUSE
                                ON ORDERS.WH_CODE = WAREHOUSE.WH_CODE
                                WHERE WAREHOUSE.WH_NAME = '浦和倉庫')
JOIN ITEM
ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
GROUP BY ITEM.ITEM_CODE