select 
 c.ITEM_CODE as CODE  ,d.ITEM_NAME as NAME ,sum(ORDER_QTY) as SUM_QTY

from 

orders as a  left join warehouse as b 
on a.wh_code = b.wh_code left join orders_dtl as c on a.order_no = c.order_no  left join item as d  on  c.item_code =  d.item_code

where 

b.wh_name = '浦和倉庫'

group by 
    c.ITEM_CODE 

having SUM_QTY >= 50

order by 
3 desc , 1 desc