danhanPolygon VS L1 Max and Average Number of Transactions in Each Block
    Updated 2022-07-24
    with polygon as(
    select
    BLOCK_NUMBER,
    tx_count
    from polygon.core.fact_blocks
    ),
    ethereum as(
    select
    BLOCK_NUMBER,
    tx_count
    from ethereum.core.fact_blocks
    ),
    solana as(
    select
    BLOCK_ID,
    tx_count
    from solana.core.fact_blocks
    ),
    avalanche as(
    select
    BLOCK_NUMBER,
    tx_count
    from avalanche.core.fact_blocks
    ),
    bnbchain as(
    select
    BLOCK_NUMBER,
    tx_count
    from bsc.core.fact_blocks
    ),
    flow as(
    select
    BLOCK_HEIGHT,
    tx_count
    from flow.core.fact_blocks
    )
    Run a query to Download Data