select
DTL.ITEM_CODE as CODE
,ITEM_NAME as NAME
,sum(ORDER_QTY) as SUM_QTY

from 
ORDERS as ORD
inner join WAREHOUSE as WAR
on ORD.WH_CODE = WAR.WH_CODE
left join ORDERS_DTL as DTL
on ORD.ORDER_NO = DTL.ORDER_NO
left join ITEM
on DTL.ITEM_CODE = ITEM.ITEM_CODE

where 
WAR.WH_NAME = '浦和倉庫'
--倉庫データ(WAREHOUSE)の倉庫名(WH_NAME)が「浦和倉庫」となっている

group by 
DTL.ITEM_CODE
--商品コード(ITEM_CODE)毎に集計

having 
sum(DTL.ORDER_QTY) >= 50
--集計した数量が50個以上となる商品を表示すること

order by 
sum(DTL.ORDER_QTY) desc
,DTL.ITEM_CODE desc