SELECT
  dtl.ITEM_CODE AS CODE,
  ITEM_NAME AS NAME,
  SUM(ORDER_QTY) AS SUM_QTY
FROM
  ORDERS_DTL AS dtl
  LEFT OUTER JOIN ORDERS AS ord ON dtl.ORDER_NO = ord.ORDER_NO
  LEFT OUTER JOIN WAREHOUSE AS wh ON ord.WH_CODE = wh.WH_CODE
  LEFT OUTER JOIN ITEM AS itm ON dtl.ITEM_CODE = itm.ITEM_CODE
WHERE
  WH_NAME = "浦和倉庫"
GROUP BY
  dtl.ITEM_CODE
HAVING
  SUM(ORDER_QTY) >= 50
ORDER BY
  SUM_QTY desc,
  CODE desc;