select 
    ORDERS_DTL.ITEM_CODE as CODE,
    ITEM.ITEM_NAME as NAME,
    SUM(ORDERS_DTL.ORDER_QTY) as SUM_QTY 
  from ORDERS
  left join WAREHOUSE
         on ORDERS.WH_CODE  = WAREHOUSE.WH_CODE 
  left join ORDERS_DTL
         on ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
  left join ITEM
         on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
 where WAREHOUSE.WH_NAME = '浦和倉庫' 
 group by ORDERS_DTL.ITEM_CODE, ITEM.ITEM_NAME
 having SUM(ORDERS_DTL.ORDER_QTY) >= 50
 order by SUM_QTY DESC, SUM_QTY DESC;