select case
when block_timestamp::date between '2022-04-27' and '2022-05-03' then 'a week before'
when block_timestamp::date between '2022-05-04' and '2022-05-10' then 'May 4th to 10th'
when block_timestamp::date between '2022-05-11' and '2022-05-17' then 'a week after' end as date,
count(distinct address)
from flipside_prod_db.algorand.account, flipside_prod_db.algorand.block
where created_at = block_id and block_timestamp::date between '2022-04-27' and '2022-05-17'
group by 1