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