Cumulative Spending by Species :Visualize Spending Distribution Within Each Species to Understand Cumulative Contribution Patterns Intermediate

          with customertotals as
  (select c.species,
          o.customerid,
          sum(o.totalamount) as totalspending
   from orders o
   join customers c on o.customerid = c.customerid
   group by c.species,
            o.customerid)
select species,
       customerid,
       totalspending,
       cume_dist() over (partition by species
                         order by totalspending desc) as spendingdistribution
from customertotals;