select

tx_hash,

block_timestamp,

origin_from_address as user,

contract_address

from

mezo.testnet.fact_event_logs

where

tx_succeeded

),

contract_tx_counts as (

select

contract_address,

count(*) as tx_count

from

main

group by

contract_address

),

categorized_contracts as (

select

contract_address,

tx_count,

case

when tx_count >= 10000 then '🏦 Super Contract (10k+ txs)'

when tx_count >= 1000 then '🔥 Hot Contract (1k - 9,999 txs)'

when tx_count >= 100 then '🌱 Growing Contract (100 - 999 txs)'

else '🧪 Newbie (0 - 99 txs)'

end as category

from

contract_tx_counts

),

category_summary as (

select

category,