SELECT sender AS address, platform

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, platform

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

Bridges_Count.range AS num_bridges_range,

COUNT(subquery.address) AS num_wallets

FROM (

SELECT

address,

COUNT(DISTINCT platform) AS tot_bridges

FROM Full_tb

WHERE address != '0x0000000000000000000000000000000000000000'

GROUP BY address

) subquery

CROSS JOIN (

VALUES

(1, '1 Bridge'),

(2, '2 Bridges'),

(3, '3 Bridges'),

(4, '4 or more Bridges')

) Bridges_Count(count_threshold, range)

WHERE subquery.tot_bridges >= Bridges_Count.count_threshold

GROUP BY Bridges_Count.range