Category Revenue Rankings :Rank Product Categories by Total Sales with Tie-Aware Revenue Comparison Advanced

          with categorysales as
  (select p.category,
          sum(od.quantity * p.price) as totalrevenue
   from orderdetails od
   join products p on od.productid = p.productid
   group by p.category)
select category,
       totalrevenue,
       dense_rank() over (
                          order by totalrevenue desc) as rank
from categorysales;