SELECT
  OD.ITEM_CODE AS CODE
, I.ITEM_NAME NAME
, SUM(ORDER_QTY) AS SUM_QTY
FROM
  ORDERS_DTL OD
  LEFT JOIN ORDERS O ON O.ORDER_NO = OD.ORDER_NO
  LEFT JOIN WAREHOUSE W ON O.WH_CODE = W.WH_CODE
  LEFT JOIN ITEM I ON I.ITEM_CODE = OD.ITEM_CODE
WHERE
  W.WH_NAME = "浦和倉庫"
GROUP BY
  I.ITEM_CODE
, I.ITEM_NAME
HAVING
  SUM(ORDER_QTY) >= 50
ORDER BY
  SUM(ORDER_QTY) DESC
, I.ITEM_CODE DESC;