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