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