with s as (
select
d.ITEM_CODE as ITEM_CODE,
sum(d.ORDER_QTY) as SUM_QTY
from
ORDERS o, WAREHOUSE w, ORDERS_DTL d
where WH_NAME = '浦和倉庫'
and o.WH_CODE=w.WH_CODE
and o.ORDER_NO = d.ORDER_NO
group by o.ORDER_NO,d.ITEM_CODE
)
select
s.ITEM_CODE as CODE,
COALESCE(i.ITEM_NAME, 'NULL') as NAME,
s.SUM_QTY as SUM_QTY
from
s
LEFT JOIN
    ITEM i ON s.ITEM_CODE = i.ITEM_CODE
where s.SUM_QTY >= 50
order by 3 desc, 1 desc