with other_chains as (

with tab1 as (select blockchain as "Chain", sum(tx_count) as "Txns Count"

from external.artemis.tx_count

where block_date>=current_date-30

group by 1

union all

select blockchain as "Chain", sum(tx_count) as "Txns Count"

from external.bitquery.tx_count

where blockchain not in ('algorand','cardano','celo_mainnet','moonbeam')

and block_date>=current_date-30

group by 1)

select *

from tab1),

aleo as (select 'Aleo' as "Chain", count(distinct tx_id) as "Txns Count"

from aleo.core.fact_transitions

where block_timestamp::date>=current_date-30

group by 1),

aptos as (select 'Aptos' as "Chain", count(distinct tx_hash) as "Txns Count"

from aptos.core.fact_transactions

where block_timestamp::date>=current_date-30

group by 1),

arbitrum as (select 'Arbitrum' as "Chain", count(distinct tx_hash) as "Txns Count"

from arbitrum.core.fact_transactions

where block_timestamp::date>=current_date-30

group by 1),

aurora as (select 'Aurora' as "Chain", count(distinct tx_hash) as "Txns Count"

from aurora.core.fact_transactions

where block_timestamp::date>=current_date-30