-- forked from Eman-Raz / coq pools count @ https://flipsidecrypto.xyz/Eman-Raz/q/kvpLbLMZhgA_/coq-pools-count
SELECT count(distinct pool_address) as pool_count
FROM avalanche.defi.dim_dex_liquidity_pools
WHERE TOKENS:token0='0x420fca0121dc28039145009570975747295f2329'
OR TOKENS:token1='0x420fca0121dc28039145009570975747295f2329'