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