select 
od.ITEM_CODE  as CODE,
i.ITEM_NAME as NAME,
SUM(od.ORDER_QTY) as SUM_QTY


from WAREHOUSE w INNER JOIN ORDERS o ON w.WH_CODE = o.WH_CODE
INNER JOIN ORDERS_DTL od ON o.ORDER_NO = od.ORDER_NO 
LEFT OUTER JOIN ITEM i ON od.ITEM_CODE  = i. ITEM_CODE 

where w.WH_NAME = '浦和倉庫'
GROUP BY CODE
HAVING SUM(od.ORDER_QTY) >= 50
order by SUM_QTY DESC, CODE DESC;