case when swap_from_amount < 10 then 'Less Than 10 SRM'

when swap_from_amount >= 10 and swap_from_amount < 100 then '10 - 100 SRM'

when swap_from_amount >= 100 and swap_from_amount < 1000 then '100 - 1000 SRM'

else 'More Than 1000 SRM' end as volume_type,

count (distinct tx_id) as Swaps_Count

from solana.core.fact_swaps

where succeeded = 'TRUE'

and swap_from_mint = 'SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt'

and block_timestamp >= CURRENT_DATE - 21

group by 1,2

order by 1