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) desc,D.item_code desc ) 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)