select  dtl.ITEM_CODE       AS CODE
,       itm.ITEM_NAME       AS NAME
,       SUM(dtl.ORDER_QTY)  AS SUM_QTY
from ORDERS_DTL dtl
left join ITEM itm
   on itm.ITEM_CODE = dtl.ITEM_CODE
where exists(
    select 1
    from ORDERS ord
    inner join WAREHOUSE wh
       on wh.WH_CODE = ord.WH_CODE
    where wh.WH_NAME = '浦和倉庫'
      and ord.ORDER_NO = dtl.ORDER_NO
)
group by CODE, NAME
having SUM_QTY >= 50
order by SUM_QTY desc, CODE desc