SELECT
    OD.ITEM_CODE AS ITEM_CODE
    ,I.ITEM_NAME AS NAME
    ,SUM(OD.ORDER_QTY) AS SUM_QTY

FROM
    ORDERS AS O
INNER JOIN ORDERS_DTL AS OD
    ON O.ORDER_NO = OD.ORDER_NO
LEFT JOIN ITEM AS I
    ON OD.ITEM_CODE = I.ITEM_CODE
INNER JOIN WAREHOUSE AS W
    ON O.WH_CODE = W.WH_CODE
WHERE
    W.WH_NAME = '浦和倉庫'

GROUP BY OD.ITEM_CODE ,I.ITEM_NAME
HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC
,I.ITEM_CODE DESC