update item
set ITEM_POPULAR_RANK =coalesce((select rnk
                        from (select D.item_code
                                   , rank() over (order by sum(ORDER_QTY) desc,max(ORDER_DATE),D.item_code) as rnk
                              from ORDERS O
                                   inner join ORDERS_DTL D
                                              on O.ORDER_NO = D.ORDER_NO
                              where ORDER_DATE between '2023-04-01' and '2023-06-30'
                              group by D.item_code) tbl
                        where tbl.item_code = item.item_code),0)