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