select distinct SWAP_PROGRAM,
count (TX_ID) as total_Swpas
from solana.defi.fact_swaps
where SWAP_FROM_MINT = 'MEW1gQWJ3nEXg2qgERiKu7FAFj79PHvQVREQUzScPP5'
OR SWAP_TO_MINT = 'MEW1gQWJ3nEXg2qgERiKu7FAFj79PHvQVREQUzScPP5'
and SUCCEEDED = 'TRUE'
group by 1
order by 2 desc