SELECT T2.ITEM_CODE AS CODE,
IT.ITEM_NAME AS NAME,
SUM (T2.ORDER_QTY) AS SUM_QTY
FROM ORDERS AS T1
 INNER JOIN ORDERS_DTL AS T2
  ON T1.ORDER_NO = T2.ORDER_NO
 INNER JOIN WAREHOUSE AS WH
  ON T1.WH_CODE =WH.WH_CODE
 OUTER LEFT JOIN ITEM AS IT
  ON T2.ITEM_CODE=IT.ITEM_CODE
 WHERE WH.WH_NAME='浦和倉庫' 
 GROUP BY T2.ITEM_CODE
 HAVING SUM_QTY>=50
 ORDER BY SUM_QTY DESC,CODE DESC;