with tmp as(
select WH_CODE
  from WAREHOUSE
 where WH_NAME = '浦和倉庫')
select b.ITEM_CODE as CODE,
(select c.item_name
   from ITEM C
  where c.ITEM_CODE = b.ITEM_CODE) as NAME,
sum(b.ORDER_QTY) as SUM_QTY
  from ORDERS a Left Join ORDERS_DTL b
    on a.ORDER_NO = b.ORDER_NO
 where a.WH_CODE in(select WH_CODE from tmp)
group by b.ITEM_CODE
having sum(b.ORDER_QTY) >= 50
order by SUM_QTY desc,CODE desc