keshanactive and inactive in jan
    Updated 2022-02-13
    with jan as (select date_trunc('month', block_timestamp) as month, count(distinct address) as created,
    sum(case when account_closed = 'TRUE' then 1 else 0 end) as closed,
    sum(case when account_closed = 'FALSE' then 1 else 0 end) as open
    from algorand.account
    left join algorand.block on block_id = created_at
    group by month)

    select month, (closed * 100 / created) as close_precentage, (open * 100 / created) as open_precentage from jan

    Run a query to Download Data