select
od.ITEM_CODE as CODE,
it.ITEM_NAME as NAME,
sum(od.ORDER_QTY) as SUM_QTY
from
ORDERS_DTL od
left join ITEM it
on od.ITEM_CODE  = it.ITEM_CODE
inner join ORDERS o
on od.ORDER_NO = o.ORDER_NO
inner join WAREHOUSE w
on o.WH_CODE = w.WH_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;