0-MIDUser count whose first and last Tx was >= 1 month by Chain
    Updated 2022-12-19
    with tab1 as (
    select PROPOSER
    ,min(BLOCK_TIMESTAMP)as min_date
    ,max(BLOCK_TIMESTAMP)as last_date
    from flow.core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-01-01'
    group by 1),
    tab2 as (
    select TX_SENDER
    ,min(BLOCK_TIMESTAMP)as min_date
    ,max(BLOCK_TIMESTAMP)as last_date
    from algorand.core.fact_transaction
    where BLOCK_TIMESTAMP>='2022-01-01'
    group by 1),
    tab3 as (
    select FROM_ADDRESS
    ,min(BLOCK_TIMESTAMP)as min_date
    ,max(BLOCK_TIMESTAMP)as last_date
    from avalanche.core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-01-01'
    group by 1),
    tab4 as (
    select FROM_ADDRESS
    ,min(BLOCK_TIMESTAMP)as min_date
    ,max(BLOCK_TIMESTAMP)as last_date
    from bsc.core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-01-01'
    group by 1),
    tab5 as (
    select TX_FROM
    ,min(BLOCK_TIMESTAMP)as min_date
    ,max(BLOCK_TIMESTAMP)as last_date
    from cosmos.core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-01-01'
    group by 1),
    tab6 as (
    Run a query to Download Data