SELECT OD.ITEM_CODE AS CODE,
       IT.ITEM_NAME AS NAME,
       SUM(OD.ORDER_QTY) AS SUM_QTY
             
       FROM WAREHOUSE AS WH
       INNER JOIN ORDERS AS ORD
       ON ORD.WH_CODE = WH.WH_CODE

       INNER JOIN ORDERS_DTL AS OD
       ON ORD.ORDER_NO = OD.ORDER_NO
       
       LEFT OUTER JOIN ITEM AS IT
       ON IT.ITEM_CODE=OD.ITEM_CODE

       WHERE WH.WH_NAME ='浦和倉庫'

       GROUP BY OD.ITEM_CODE,IT.ITEM_NAME
       HAVING SUM_QTY >=50

       ORDER BY SUM_QTY DESC,CODE DESC;