with xs as (
  select symbolic_length as bin, count(1) as count
  from extracted_clips where symbolic_length is not null
  group by 1 order by 1
) select
  bin,
  (sum(count) over
     (order by bin asc rows between unbounded preceding and current row))
  /(select sum(count) from xs) as pct
from xs order by bin asc;
