select

case

when swap_from_mint = '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr'

or swap_to_mint = '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr' then 'POPCAT'

when swap_from_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

or swap_to_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263' then 'BONK'

when swap_from_mint = 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'

or swap_to_mint = 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82' then 'BOME'

end as MemeCoin,

count(DISTINCT SWAPPER) as N_Users

from

solana.defi.fact_swaps

where

(

swap_from_mint in (

'7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr',

'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263',

'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'

)

or swap_to_mint in (

'7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr',

'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263',

'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'

)

)

AND BLOCK_TIMESTAMP >= CURrENT_TIMESTAMP - INTERVAL '30 days'

group by

1

),

tab2 as (

select

'PEPE' as MemeCoin,

count(DISTINCT ORIGIN_FROM_ADDRESS) as N_Users

from

ethereum.defi.ez_dex_swaps