select
'second half of 2021' as status,
block_timestamp::date as day,
count(distinct sender) as number_of_wallets
from flipside_prod_db.algorand.application_call_transaction
where day >= '2021-07-01'
and day < '2022-01-01'
group by day
UNION
select
'first half of 2022' as status,
block_timestamp::date as day,
count(distinct sender) as number_of_wallets
from flipside_prod_db.algorand.application_call_transaction
where day < '2022-07-01'
and day >= '2022-01-01'
group by day