SELECT * 
FROM 
(SELECT 
OD.ITEM_CODE as CODE,
ITM.ITEM_NAME as NAME,
SUM(OD.ORDER_QTY) as SUM_QTY
FROM ORDERS_DTL OD LEFT JOIN ITEM ITM
ON OD.ITEM_CODE = ITM.ITEM_CODE
WHERE 
ORDER_NO IN (
SELECT O.ORDER_NO
FROM WAREHOUSE W INNER JOIN ORDERS O ON
W.WH_CODE = O.WH_CODE

WHERE W.WH_NAME = '浦和倉庫'
)
GROUP BY OD.ITEM_CODE,ITM.ITEM_NAME
)
WHERE SUM_QTY >= 50
ORDER BY SUM_QTY DESC,CODE desc