rajsNear Blocks
Updated 2022-11-04
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
-- *
-- min(block_timestamp)
block_author,
count(*) as no_of_blocks,
sum(count(*)) over () as total_no_of_blocks,
count(*) / sum(count(*)) over () * 100 as pct_of_blocks
from near.core.fact_blocks
group by 1
order by 2 desc
-- limit 3
Run a query to Download Data