Category Supplier Spending Footprint :Analyze Customer Spending Across Product Categories and Suppliers with Ranking and Cumulative Distribution Advanced

          with category_supplier_spending as
  (select c.customerid,
          p.category,
          p.supplierid,
          sum(od.quantity * od.unitprice) as totalspending
   from orders o
   join customers c on o.customerid = c.customerid
   join orderdetails od on o.orderid = od.orderid
   join products p on od.productid = p.productid
   group by c.customerid,
            p.category,
            p.supplierid)
select customerid,
       category,
       supplierid,
       totalspending,
       rank() over (partition by category,
                                 supplierid
                    order by totalspending desc) as spendingrank,
                   cume_dist() over (partition by category,
                                                  supplierid
                                     order by totalspending desc) as spendingcumedist
from category_supplier_spending;