with a as (

select from_address as address ,

min(block_timestamp)::date as date, '2020' as years

from flipside_prod_db.polygon.transactions

group by address

having date <= '2020-12-31'

and date >= '2020-01-01'

) , b as (

select from_address as address ,

min(block_timestamp)::date as date, '2021' as years

from flipside_prod_db.polygon.transactions

group by address

having date <= '2021-12-31'

and date >= '2021-01-01'

) , c as (

select from_address as address ,

min(block_timestamp)::date as date, '2022' as years

from flipside_prod_db.polygon.transactions

group by address

having date >= '2022-01-01'

and date <= '2022-05-29'

)

select count(address)/365 as addresss,

years

from a group by years

UNION

select count(address)/365 as addresss,

years

from b group by years

UNION

select

count(address)/datediff(day, '2022-01-01', '2022-05-29') as addresss

, years

from c

group by years