select date_trunc ('day', block_timestamp) as fecha,

count(distinct tx_id) as interactions,

tx_from as users

from terra.transactions

where fecha >= CURRENT_DATE - 60

and fecha < CURRENT_DATE - 1

group by fecha, users

order by interactions desc

),

max_number as (

select users,

max (interactions) as max_interactions

from daily_count

where users is not NULL

group by users

select count (distinct users) as user_number,

max_interactions,

case

when max_interactions <= 10 then 'HUMAN'

when max_interactions <= 25 and max_interactions > 10 then 'CYBORG'

when max_interactions > 25 then 'BOT'

end as type,

sum(user_number) over (order by max_interactions) as total_users,

total_users / 865271 * 100 as total_users_perc

from max_number

group by max_interactions, type

order by max_interactions