count(distinct tx_id) as txcount

from terra.transactions

where year(block_timestamp) = '2022'

group by 1),

addy as (select address

from raw

where txcount >= 50)

select date_trunc('month', block_timestamp) as dt,

count(distinct tx_from[0]::string) as active_wallet

from terra.transactions

where year(block_timestamp) = '2022' and tx_from[0]::string in (select address from addy)

group by 1