mu-tafaUntitled Query
    Updated 2022-07-17
    with tab1 as (
    SELECT
    date_trunc(day,block_timestamp) as date,
    proposer as users
    from flow.core.fact_transactions
    where date BETWEEN '2022-05-1' and '2022-05-30' ),
    tab2 as (
    SELECT
    proposer as users,
    tx_id as tx_count,
    date_trunc(day,block_timestamp) as date
    from flow.core.fact_transactions
    where date between '2022-06-1' and '2022-06-30' )
    SELECT
    count(b.tx_count) as transaction_count,
    b.date
    from tab1 a left join tab2 b on a.users=b.users
    group by b.date
    Run a query to Download Data