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