Select

count(distinct swapper),

count(distinct tx_id),

block_timestamp::date as date,

sum(swap_from_amount) as SwappedAway,

sum(swap_to_amount) as Swappedto,

case when (swap_from_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' ) then 'usdc interaction'

when (swap_from_mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or swap_to_mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' ) then 'usdt interaction'

when (swap_from_mint='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' or swap_to_mint='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) then 'ust wormhole interaction v2'

when (swap_from_mint='CXLBjMMcwkc17GfJtBos6rQCo1ypeH6eDbB82Kby4MRm' or swap_to_mint='CXLBjMMcwkc17GfJtBos6rQCo1ypeH6eDbB82Kby4MRm' ) then 'ust wormhole interaction v1'

end as token

From solana.swaps

where swap_program='jupiter aggregator v2'

and succeeded='true' and block_timestamp::date >= '2021-12-01'

group by 3,6 having token is not null