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--, su, ma
    from (
    select ITEM_CODE , sum(ORDER_QTY) as su, max(ORDER_DATE) as ma
    from ORDERS left join ORDERS_DTL using (ORDER_NO)
    where "2023-04-01" <= ORDER_DATE and ORDER_DATE <= "2023-06-30"
    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
);

select ITEM_CODE, ITEM_POPULAR_RANK from ITEM