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