SELECT
CODE
,ITEM_NAME as NAME
,SUM_QTY
FROM
(SELECT 
  B.ITEM_CODE as CODE
 ,SUM(B.ORDER_QTY) as SUM_QTY
FROM ORDERS_DTL as B
LEFT JOIN ORDERS as A
ON A.ORDER_NO = B.ORDER_NO
LEFT JOIN WAREHOUSE as C
ON A.WH_CODE = C.WH_CODE 
WHERE C.WH_NAME = '浦和倉庫'
GROUP BY CODE) E
LEFT JOIN ITEM as D
ON E.CODE = D.ITEM_CODE
WHERE SUM_QTY>=50
ORDER BY SUM_QTY desc,CODE desc