SELECT
    ODDTL.ITEM_CODE AS CODE,
    IT.ITEM_NAME AS NAME,
    SUM(ODDTL.ORDER_QTY) AS SUM_QTY
FROM ORDERS AS OD
 INNER JOIN ORDERS_DTL AS ODDTL
  ON OD.ORDER_NO = ODDTL.ORDER_NO
 INNER JOIN WAREHOUSE AS WH
  ON OD.WH_CODE = WH.WH_CODE
 LEFT OUTER JOIN ITEM AS IT
  ON ODDTL.ITEM_CODE = IT.ITEM_CODE
WHERE WH.WH_NAME = '浦和倉庫'
GROUP BY IT.ITEM_NAME
ORDER BY SUM(ODDTL.ORDER_QTY) desc,ODDTL.ITEM_CODE desc