select IT.ITEM_CODE as CODE, ITEM_NAME as NAME,sum(ODD.ORDER_QTY) as SUM_QTY
from WAREHOUSE as WH inner join ORDERS as OD on WH.WH_CODE = OD.WH_CODE
    inner join ORDERS_DTL as ODD on OD.ORDER_NO = ODD.ORDER_NO
    left outer join ITEM as IT on ODD.ITEM_CODE = IT.ITEM_CODE
where WH.WH_NAME = '浦和倉庫'
group by ODD.ITEM_CODE
HAVING SUM_QTY>=50
order by SUM_QTY desc,CODE desc;