SELECT 
    od.item_code AS CODE,
    it.item_name AS NAME,
    SUM(od.order_qty) AS SUM_QTY
FROM 
    orders AS o
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 it ON od.item_code = it.item_code
WHERE 
    w.wh_name = '浦和倉庫'
GROUP BY 
    od.item_code, it.item_name
HAVING 
    SUM(od.order_qty) >= 50
ORDER BY 
    SUM_QTY DESC, CODE DESC;