block_author,

count(*) as block,

sum(count(*)) over () as total,

count(*) / sum(count(*)) over () * 100 as pct

from near.core.fact_blocks

group by 1

order by 2 desc