address_name,

case

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 = 'FoRGERiW7odcCBGU1bztZi16osPBHjxharvDathL5eds' then 'FORGE'

when swap_from_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST'

when swap_from_mint = 'FoXyMu5xwXre7zEoSvzViRk3nGawHUp9kUh97y2NDhcq' then 'FOXY'

when swap_from_mint = 'G9tt98aYSznRk7jWsfuz9FnTdokxS6Brohdo9hSmjTRB' then 'PUFF'

when swap_from_mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' then 'SHDW'

when swap_from_mint = 'A3HyGZqe451CBesNqieNPfJ4A9Mu332ui8ni6dobVSLB' then 'WOOP'

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 = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' then 'RAY'

when swap_from_mint = '7ScYHk4VDgSRnQngAUtQk4Eyf7fGat8P4wXq6e2dkzLj' then 'ALL'

when swap_from_mint = 'Ao94rg8D6oK2TAq3nm8YEQxfS73vZ2GWYw2AKaUihDEY' then 'CRECK'

when swap_from_mint = 'CREAMpdDimXxj2zTCwP5wMEtba4NYaKCrTBEQTSKtqHe' then 'CREAMY'

when swap_from_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ' then 'DUST'

when swap_from_mint = '2uVQjmwUbVPWQ3d1ATsJvVoiMEo8jDH8o4TmmaYAf9Ea' then 'TGG'

when swap_from_mint = 'METAewgxyPbgwsseH8T16a39CQ5VyVxZi9zXiDPY18m' then 'MPLX'

when swap_from_mint = '7xKXtg2CW87d97TXJSDpbD5jBkheTqA83TZRuJosgAsU' then 'SAMO'

when swap_from_mint = '8HGyAAB1yoM1ttS7pXjHMa3dukTFGQggnFFH3hJZgzQh' then 'COPE'

when swap_from_mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then 'ATLAS'

when swap_from_mint = 'VVWAy5U2KFd1p8AdchjUxqaJbZPBeP5vUQRZtAy8hyc' then 'Flip.gg'

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 = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'