SELECT 
od.item_code CODE,
CASE  
WHEN i.item_name IS NULL THEN NULL
ELSE i.item_name
END NAME
,
sum(order_qty) SUM_QTY
FROM 
ORDERS o
inner join 
ORDERS_DTL od on o.order_no=od.order_no
inner join warehouse w on o.wh_code=w.wh_code
left join item i on od.item_code=i.item_code
where WH_NAME='浦和倉庫'
group by od.item_code,i.item_name
having sum(order_qty)>=50
ORDER BY SUM_QTY desc, CODE desc