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