select
  OD.ITEM_CODE AS CODE
  , I.ITEM_NAME AS NAME
  , SUM(OD.ORDER_QTY) AS SUM_QTY
from
  WAREHOUSE AS WH
  inner join ORDERS AS O
    on WH.WH_CODE = O.WH_CODE
  inner join ORDERS_DTL AS OD
    on O.ORDER_NO = OD.ORDER_NO
  left outer join ITEM AS I
    on OD.ITEM_CODE = I.ITEM_CODE
where
  WH_NAME = '浦和倉庫'
group by
  OD.ITEM_CODE
having
  SUM_QTY >= 50
order by
  SUM_QTY desc
  , I.ITEM_CODE desc
;