f.swap_program,

COUNT(DISTINCT e.tx_id) AS Swaps,

COUNT(DISTINCT e.swapper) AS Swappers,

SUM(NVL(e.SWAP_FROM_AMOUNT_USD, e.SWAP_TO_AMOUNT_USD)) AS Total_Swap_Volume_USD,

AVG(NVL(e.SWAP_FROM_AMOUNT_USD, e.SWAP_TO_AMOUNT_USD)) AS Average_Swap_Volume

FROM

solana.defi.fact_swaps f

JOIN

solana.defi.ez_dex_swaps e

ON f.tx_id = e.tx_id

WHERE

(e.Swap_from_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'

OR e.swap_to_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv')

GROUP BY

f.swap_program

ORDER BY

Total_Swap_Volume_USD DESC