select signers[0] as address,

count(distinct tx_id) as eclipse_tx_count

from eclipse.core.fact_transactions

where block_timestamp >= '2024-08-25'

group by address

),

solana_addresses as (

select signers[0] as address,

count(distinct tx_id) as solana_tx_count

from solana.core.fact_transactions

where block_timestamp >= '2024-08-25'

group by address

),

common_addresses as (

select

e.address,

e.eclipse_tx_count,

s.solana_tx_count,

(e.eclipse_tx_count + s.solana_tx_count) as total_transactions

from

eclipse_addresses e

join

solana_addresses s on e.address = s.address

select

address,

eclipse_tx_count,

solana_tx_count,

total_transactions

from

common_addresses

order by

eclipse_tx_count desc

limit 100