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