with sender_tb as (

SELECT sender as address, destination_chain

FROM ethereum.defi.ez_bridge_activity

WHERE block_timestamp > '2023-10-01' AND Destination_chain in ('near', 'solana', 'sui', 'osmosis', 'aptos', 'fantom', 'telos','sei','injective')

),

origin_tb as (

SELECT origin_from_address as address, destination_chain

FROM ethereum.defi.ez_bridge_activity

WHERE block_timestamp > '2023-10-01' AND Destination_chain in ('near', 'solana', 'sui', 'osmosis', 'aptos', 'fantom', 'telos','sei','injective')

),

full_tb as (

SELECT * FROM sender_tb

UNION ALL

SELECT * FROM origin_tb

SELECT destination_chain, count(DISTINCT address) as n_bridger

FROM full_tb

GROUP BY destination_chain

order by n_bridger desc