Customer Revenue Trajectory :Analyze Cumulative Revenue Distribution to Understand Customer Spending Patterns Intermediate

          with customertotals as
  (select o.customerid,
          sum(o.totalamount) as totalspending
   from orders o
   group by o.customerid)
select customerid,
       totalspending,
       cume_dist() over (
                         order by totalspending desc) as revenuedistribution
from customertotals;