granadohoContent of Largest Block
    Updated 2022-01-20
    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