when amount<=10 then 'V<=10'

when amount>10 and amount<=100 then '10<V<=100'

when amount>100 and amount<=1000 then '100<V<=1k'

when amount>1000 and amount<=10000 then '1k<V<=10k'

when amount>10000 and amount<=100000 then '10k<V<=100k'

when amount>100000 and amount<=1000000 then '100k<V<=1M'

when amount>1000000 then 'V>1M'

end as "Class"

from blast.core.ez_token_transfers

where origin_function_signature='0xcd9829d9'

and origin_to_address='0xf7be503166828fe8565c520d66645ac6a06bbdd7'

and contract_address='0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad'

and from_address='0xf7be503166828fe8565c520d66645ac6a06bbdd7'

and to_address<>'0xa4bd562c37c19c569c5b4418d12d35fa9964931f')

select "Class", count(distinct to_address) as "Claimer Count"

from tab1

group by 1