-- forked from SocioCrypto / Number of users who have interacted with Squid (source_chain) @ https://flipsidecrypto.xyz/SocioCrypto/q/BEvKekfHKHsn/number-of-users-who-have-interacted-with-squid-source_chain
with tb0 as (
SELECT
sender,
count(DISTINCT source_chain) as n_source_chain,
count(DISTINCT destination_chain) as n_destination_chain
FROM axelar.core.ez_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