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