SELECT designation, count(*) AS n,
  round(100.0*count(*)/sum(count(*)) over (),1) AS pct
FROM public.fec_committees GROUP BY designation ORDER BY n DESC;
-- treasurer gap:
SELECT count(*) FILTER (WHERE treasurer_name IS NULL OR treasurer_name='') AS no_treasurer,
  count(*) AS total FROM public.fec_committees;
