SELECT
    od.item_code AS CODE
    ,i.item_name AS NAME
    ,SUM(od.order_qty) AS SUM_QTY
FROM
    ORDERS_DTL od
    LEFT JOIN ITEM i
    ON od.item_code = i.item_code
    INNER JOIN     ORDERS o
    ON o.order_no = od.order_no
    INNER JOIN WAREHOUSE w
    ON o.wh_code = w.wh_code

    
WHERE
     w.wh_name = '浦和倉庫'
GROUP BY
     od.item_code
HAVING
    SUM(od.order_qty) >= 50
ORDER BY
    SUM_QTY DESC
    ,CODE ASC