Query editor
with a as (select"from" as address,count(distinct date_trunc('day', block_time)) as count_daysfrom ethereum.transactionswhere block_time > now() - interval '365' daygroup by 1),b as (selectcount_days,count(*) as active_addressesfrom agroup by 1)selectcasewhen count_days = 1 then '1 day'when count_days = 2 then '2 days'when count_days between 3 and 7 then '3-7 days'when count_days between 8 and 30 then '8-30 days'when count_days between 31 and 90 then '31-90 days'else '91-365 days'end as activity_group,sum(active_addresses) as active_addressesfrom bgroup by 1order by min(count_days)