select

contract_address,

count(tx_hash) as tx_count

from flow.core_evm.fact_event_logs

where tx_succeeded

group by contract_address

select

case

when tx_count > 10000 then 'High Activity'

when tx_count between 1000 and 10000 then 'Medium Activity'

else 'Low Activity'

end as contract_category,

count(contract_address) as contract_count

from contract_tx_count

group by contract_category