SELECT
　 odd.ITEM_CODE AS CODE,
    it.ITEM_NAME AS NAME,
    SUM(odd.ORDER_QTY) AS SUM_QTY
FROM WAREHOUSE AS wa
    JOIN ORDERS AS od
    ON wa.WH_CODE ＝ od.WH_CODE

    JOIN ORDERS_DTL AS odd
    ON od.ORDER_NO = odd.ORDER_NO

    LEFT OUTER JOIN ITEM AS it
    ON odd.ITEM_CODE = it.ITEM_CODE

WHERE wa.WH_NAME = '浦和倉庫'
GROUP BY odd.ITEM_CODE,
    it.ITEM_NAME
HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC,
    CODE DESC;