from ink.core.fact_transactions

where tx_succeeded='TRUE'),

Blast as (select from_address as user, tx_hash

from Blast.core.fact_transactions

where status='SUCCESS')

select ink.user as user, count(distinct tx_hash) as txns_count, 'Blast' as "Chain"

from ink left join Blast on ink.user=Blast.user

group by 1)

select "Chain", count(distinct user) as "Number of Users"

from overview

where txns_count>0

group by 1