select b.ITEM_CODE CODE,
d.ITEM_NAME NAME,
sum(b.ORDER_QTY) SUM_QTY
from ORDERS_DTL b
left join ORDERS a on a.ORDER_NO = b.ORDER_NO
left join WAREHOUSE c on a.WH_CODE = c.WH_CODE
left join ITEM d on b.ITEM_CODE = d.ITEM_CODE
where c.WH_NAME = '浦和倉庫'
group by b.ITEM_CODE,d.ITEM_NAME
having SUM_QTY >= 50
order by SUM_QTY desc,CODE desc