granadohoContent of Largest Block
Updated 2022-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with max_block_size as (
select
block_id,
count(block_id) as amount_of_transaction
from algorand.transactions
group by block_id
order by amount_of_transaction DESC
limit 1
), block_content as (
select
*
from algorand.transactions
where block_id = (select block_id from max_block_size)
)
select
t1.tx_type_name as transaction_type,
count(t1.tx_type_name) as amount_transaction
from block_content as t1
group by t1.tx_type_name
Run a query to Download Data