SELECT 
    D.ITEM_CODE AS CODE,
    I.ITEM_NAME AS NAME,
    SUM(D.ORDER_QTY) AS SUM_QTY
FROM ORDERS_DTL AS D
LEFT OUTER JOIN ITEM AS I
    ON D.ITEM_CODE=I.ITEM_CODE
WHERE 
    D.ORDER_NO IN
        (SELECT O.ORDER_NO FROM ORDERS AS O, WAREHOUSE AS W WHERE O.WH_CODE=W.WH_CODE AND WH_NAME='浦和倉庫')
GROUP BY CODE
HAVING SUM_QTY>=50
ORDER BY
    SUM_QTY DESC,
    CODE DESC;