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