select
OD.ITEM_CODE as CODE
, I.ITEM_NAME as NAME
, SUM(OD.ORDER_QTY) as SUM_QTY
from
ORDERS_DTL OD
inner join 
ORDERS O
on OD.ORDER_NO = O.ORDER_NO
inner join
WAREHOUSE W
on O.WH_CODE = W.WH_CODE
left join
ITEM I
on OD.ITEM_CODE = I.ITEM_CODE

where
W.WH_NAME = '浦和倉庫'

group by
OD.ITEM_CODE
, I.ITEM_NAME
having
SUM(OD.ORDER_QTY) >= 50

order by
SUM_QTY desc, CODE desc