select d.ITEM_CODE as CODE,
i.ITEM_NAME as NAME,
sum(d.ORDER_QTY) as SUM_QTY
from ORDERS o
inner join ORDERS_DTL d
on d.ORDER_NO = o.ORDER_NO
inner join WAREHOUSE w
on w.WH_CODE = o.WH_CODE
left join item i
on i.item_code = d.item_code
where w.WH_NAME = '浦和倉庫'
group by d.ITEM_CODE
having sum(d.ORDER_QTY) >= 50
order by SUM_QTY desc,
CODE desc;