date,

case when trxs>=10 and trxs<15 then '10 to 15 trxs'

when trxs>=15 and trxs<20 then '15 to 20 trxs'

when trxs>=20 and trxs<30 then '20 to 30 trxs'

else 'more than 30 trxs'

end as activity

from (SELECT date(block_timestamp) as date,

SENDER,

count(TX_ID) AS trxs

from osmosis.core.fact_transfers

WHERE block_timestamp >= '2022-01-01'

GROUP by 1, 2

order by 1 DESC

)

where trxs >= 10

group by 2, 3