WITH sub1 AS(select
    ITEM_CODE AS CODE,
    SUM(ORDER_QTY) AS SUM_QTY
from
    (
        select
            WH_CODE
        from
            WAREHOUSE
        where
            WH_NAME = '浦和倉庫'
    ) URAWA,
    ORDERS,
    ORDERS_DTL
where ORDERS.WH_CODE = URAWA.WH_CODE
AND ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
GROUP BY ITEM_CODE
HAVING SUM(ORDER_QTY)>=50)
select sub1.CODE AS CODE,item.ITEM_NAME AS NAME,sub1.SUM_QTY AS SUM_QTY
from sub1
left join ITEM item on sub1.CODE = item.ITEM_CODE
order by SUM_QTY desc,CODE desc