SELECT ordd.ITEM_CODE AS CODE
    ,it.ITEM_NAME AS NAME
    ,SUM(ordd.ORDER_QTY) AS SUM_QTY 
FROM ORDERS AS ord
JOIN ORDERS_DTL AS ordd
ON ord.ORDER_NO = ordd.ORDER_NO

JOIN WAREHOUSE AS war
ON ord.WH_CODE = war.WH_CODE

LEFT OUTER JOIN ITEM AS it
ON ordd.ITEM_CODE = it.ITEM_CODE
WHERE war.WH_NAME = '浦和倉庫'
GROUP BY ordd.ITEM_CODE
    ,it.ITEM_NAME
HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC
    ,CODE DESC;