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