'Cosmos' as Blockchain

,count (distinct attribute_value) as wallets

from cosmos.core.fact_msg_attributes

where msg_type = 'transfer'

and attribute_key = 'recipient'

group by 1

union all

select

'Osmosis' as Blockchain

,count (distinct tx_from)

from osmosis.core.fact_transactions

group by 1

union all

select

'Terra' as Blockchain

,count (distinct tx_sender)

from terra.core.fact_transactions

group by 1