SELECT
    od.item_code AS CODE
    ,i.item_name AS NAME
    ,SUM(od.order_qty) AS SUM_QTY
FROM
    ORDERS o
    INNER JOIN WAREHOUSE w
    ON o.wh_code = w.wh_code
    INNER JOIN ORDERS_DTL od
    ON o.order_no = od.order_no
    LEFT JOIN ITEM i
    ON od.item_code = i.item_code
WHERE
     w.wh_name = '浦和倉庫'
GROUP BY
     od.item_code
    ,i.item_name
HAVING
    SUM(od.order_qty) >= 50
ORDER BY
    SUM_QTY DESC
    ,CODE ASC