CASE

WHEN swap_from_mint = 'A3HyGZqe451CBesNqieNPfJ4A9Mu332ui8ni6dobVSLB' THEN 'WOOP'

WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' THEN 'SOL'

WHEN swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'

WHEN swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'

WHEN swap_from_mint = 'CREAMpdDimXxj2zTCwP5wMEtba4NYaKCrTBEQTSKtqHe' THEN 'CREAMY'

WHEN swap_from_mint = 'FoRGERiW7odcCBGU1bztZi16osPBHjxharvDathL5eds' THEN 'FORGE'

WHEN swap_from_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' THEN 'UST'

WHEN swap_from_mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' THEN 'RAY'

WHEN swap_from_mint = 'G9tt98aYSznRk7jWsfuz9FnTdokxS6Brohdo9hSmjTRB' THEN 'PUFF'

WHEN swap_from_mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN 'SHDW'

WHEN swap_from_mint = 'FoXyMu5xwXre7zEoSvzViRk3nGawHUp9kUh97y2NDhcq' THEN 'FOXY'

WHEN swap_from_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' THEN 'GST'

WHEN swap_from_mint = '7s6NLX42eURZfpyuKkVLrr9ED9hJE8718cyXFsYKqq5g' THEN 'GEAR'

WHEN swap_from_mint = '6naWDMGNWwqffJnnXFLBCLaYu1y5U9Rohe5wwJPHvf1p' THEN 'SCRAP'

WHEN swap_from_mint = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx' THEN 'GMT'

WHEN swap_from_mint = '7ScYHk4VDgSRnQngAUtQk4Eyf7fGat8P4wXq6e2dkzLj' THEN 'ALL'

WHEN swap_from_mint = 'Ao94rg8D6oK2TAq3nm8YEQxfS73vZ2GWYw2AKaUihDEY' THEN 'CRECK'

ELSE address_name

END AS token_names,

COUNT(distinct(tx_id)) AS count_tx,

row_number() over (ORDER BY count_tx ASC)

FROM solana.fact_swaps a

LEFT JOIN solana.dim_labels b

ON a.swap_from_mint= b.address

WHERE succeeded = 'TRUE'

AND swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

AND swap_from_amount > 0

AND swap_to_amount > 0

GROUP BY 1,2

ORDER BY 4 DESC

LIMIT 10