Delamir-601403- new users in each year
    Updated 2023-01-25
    with New_User as (
    select
    min(block_timestamp::date) as date,
    from_address
    from ethereum.core.fact_transactions
    where to_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
    group by 2
    )
    , Num as (
    select
    date,
    case when date > '2021-01-01' and date < '2022-01-01' then '2021'
    when date >= '2022-01-01' and date < '2023-01-01' then '2022'
    else '2023' end as Years,
    count (from_address) as Num_New_user
    from new_user
    group by 1,2
    order by 1
    )
    select
    years,
    sum(Num_New_user)
    from Num
    group by 1

    Run a query to Download Data