update ITEM set ITEM_POPULAR_RANK = 0;

update ITEM set ITEM_POPULAR_RANK = (select rank from (



select ITEM_CODE, ifnull(rank, 0) as rank from (
    select ITEM_CODE, rank from ITEM
    left outer join (
    select row_number() over (order by su desc, ma desc, ITEM_CODE desc) as rank, ITEM_CODE
    from (
    select ITEM_CODE , sum(ORDER_QTY) as su, max(ORDER_DATE) as ma
    from ORDERS left join ORDERS_DTL using (ORDER_NO)
    group by ITEM_CODE
    order by su desc, ma desc, ITEM_CODE desc
    )
    ) using (ITEM_CODE)
)


) as t1
where ITEM.ITEM_CODE = t1.ITEM_CODE
);