(

select

date_trunc('day', block_timestamp) as day,

tx_from[0] as wallet

,count(tx_id) as count_txs

from terra.transactions

where date_trunc('year', block_timestamp)='2022-01-01' --and count_txs>='1'

group by 1,2

order by 3 asc

select

date_trunc('month' , block_timestamp) as Month,

COUNT(distinct tx_from) as Num_ActiveWallets

from terra.transactions

where date_trunc('year', block_timestamp)='2022-01-01' and tx_from[0] in (select wallet from a where count_txs>=5 ) and date_trunc('day', block_timestamp)<'2022-05-01'

group by 1

order by 1 asc