select
d.*
from 
(
SELECT
b.ITEM_CODE as CODE
,(SELECT c.ITEM_NAME FROM ITEM c WHERE c.ITEM_CODE = b.ITEM_CODE) AS NAME
,SUM(b.ORDER_QTY) AS SUM_QTY
FROM ORDERS a
LEFT JOIN ORDERS_DTL b ON(a.ORDER_NO = b.ORDER_NO)
LEFT JOIN WAREHOUSE w ON(w.WH_CODE = a.WH_CODE)
WHERE w.WH_NAME = '浦和倉庫'
GROUP BY b.ITEM_CODE
) d
where d.SUM_QTY >= 50
order by d.SUM_QTY desc,d.CODE desc