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