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', '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', 'telos','sei','injective')

),

full_tb as (

SELECT * FROM sender_tb

UNION ALL

SELECT * FROM origin_tb

SELECT address, COUNT(DISTINCT destination_chain) as tot_chain

FROM full_tb

WHERE address != '0x0000000000000000000000000000000000000000'

GROUP BY address

ORDER BY tot_chain DESC