with rnktbl as (select item_code,
                      sum(unitprice * sales_qty)                             uri
--                        ,rank() over (order by sum(unitprice * sales_qty) desc) rnk

                from SALES
                         inner join SALES_DTL as dtl on sales.sales_no = dtl.sales_no
                where sales_date between '2023-06-01' and '2023-06-30'
                group by item_code
                order by 2 desc)


select rnktbl.item_code,sum(t2.uri)
from rnktbl
         inner join rnktbl t2 on rnktbl.uri>=t2.uri
group by rnktbl.item_code;
-- with rnktbl as (select item_code,
--                       sum(unitprice * sales_qty)                             uri
-- --                        ,rank() over (order by sum(unitprice * sales_qty) desc) rnk

--                 from SALES
--                          inner join SALES_DTL as dtl on sales.sales_no = dtl.sales_no
--                 where sales_date between '2023-06-01' and '2023-06-30'
--                 group by item_code
--                 order by 2 desc)
-- select * from rnktbl