-- forked from Number of users who have interacted with Squid (source_chain) @ https://flipsidecrypto.xyz/edit/queries/f70ce9b7-0d0c-4b33-8fb2-be329c75866c
with tb0 as (
SELECT
sender,
count(DISTINCT source_chain) as n_source_chain,
count(DISTINCT destination_chain) as n_destination_chain
FROM axelar.defi.ez_bridge_squid
WHERE token_symbol in ('axlUSDC','USDC', 'axlUSDT', 'USDT', 'axlWMAI')
GROUP BY 1
ORDER BY 3 DESC
)
SELECT
n_source_chain || ' chain' as n_chains,
count(sender) as users
FROM tb0
GROUP BY 1