SELECT
    SUM_ORD_DTL.ITEM_CODE as CODE,
    SUM_ORD_DTL.ITEM_NAME as NAME,
    SUM_ORD_DTL.SUM_QTY as SUM_QTY
FROM
    WAREHOUSE
INNER JOIN ORDERS
    ON WAREHOUSE.WH_CODE = ORDERS.WH_CODE
    AND WAREHOUSE.WH_NAME = '浦和倉庫'
INNER JOIN (
    SELECT
        ORDERS_DTL.ORDER_NO AS ORDER_NO,
        ORDERS_DTL.ITEM_CODE AS ITEM_CODE,
        ITEM.ITEM_NAME AS ITEM_NAME,
        SUM(ORDERS_DTL.ORDER_QTY) AS SUM_QTY
    FROM
        ORDERS_DTL
    LEFT OUTER JOIN ITEM
        ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
    GROUP BY
        ORDERS_DTL.ITEM_CODE
    HAVING
        SUM(ORDERS_DTL.ORDER_QTY) >= 50
) as SUM_ORD_DTL
    ON ORDERS.ORDER_NO = SUM_ORD_DTL.ORDER_NO