SELECT
    od.item_code AS CODE
    , i.item_name AS NAME
    , SUM(od.ORDER_QTY) AS SUM_QTY
FROM
    orders AS o
LEFT JOIN
    warehouse AS w
ON
    o.wh_code = w.wh_code
LEFT JOIN
    orders_dtl AS od
ON
    o.order_no = od.order_no
LeFT JOIN
    item AS i
ON
    od.item_code = i.item_code
WHERE
    w.wh_name = '浦和倉庫'
GROUP BY
    CODE
    , NAME
HAVING
    SUM(od.ORDER_QTY) >= 50
ORDER BY
    SUM_QTY DESC
    , CODE DESC