select
od.item_code as CODE,
i.item_name as NAME,
sum(od.order_qty) as SUM_QTY
from WAREHOUSE as w
left join orders as o on w.wh_code = o.wh_code
left join orders_dtl as od on od.order_no = o.order_no
left join item as i on od.item_code = i.item_code
where w.wh_name = '浦和倉庫'
group by CODE
having SUM_QTY >= 50
order by SUM_QTY desc, CODE desc
;