with r as(
    select
    item_code
    ,rank()over(order by sum(item_code) desc,order_date desc,item_code desc) as r
    from orders as o
    inner join orders_dtl as od
    on o.order_no=od.order_no
    where order_date between '2023-04-01' and '2023-06-30'
    group by item_code
)
update item
set item_popular_rank =
ifnull((select r from r where item.item_code = r.item_code),0)