with flow as (select
    date_trunc('day',block_timestamp::date) as "Date" ,count(distinct tx_id) as "Number of Daily Transactions",
    ("Number of Daily Transactions"/86400) as "Flow - TPS"
    from flow.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    and TX_SUCCEEDED = true
    group by 1
    order by 1
    ),
    solana as (select date_trunc('day',block_timestamp::date) as "Date", count(distinct tx_id) as "Number of Daily Transactions",
    ("Number of Daily Transactions"/86400) as "Solana - TPS"
    from solana.fact_transactions
    where block_timestamp >='2022-01-01'
    and SUCCEEDED = true
    group by 1
    order by 1
    ),
    algorand as (
    select date_trunc('day',block_timestamp::date) as "Date", count(distinct tx_id) as "Number of Daily Transactions",
    ("Number of Daily Transactions"/86400) as "Algorand - TPS"
    from algorand.transactions
    where block_timestamp >='2022-01-01'
    group by 1
    order by 1
    )

    select flow."Date", flow."Flow - TPS", solana."Solana - TPS", algorand."Algorand - TPS"
    from flow
    join solana ON solana."Date"=flow."Date"
    join algorand ON algorand."Date"=flow."Date"
    order by 1
    Run a query to Download Data