case when to_address='0xddb6dcce6b794415145eb5caa6cd335aeda9c272' then 'CatAttackNFT'

when to_address='0x4200000000000000000000000000000000000015' then 'Genesis 2'

when to_address='0x4200000000000000000000000000000000000016' then 'Genesis 1'

when to_address='0x2a7343298260acddca850fe58a88998c0f76aa63' then 'Azuland Mint 2'

when to_address='0x14acba2bab926c6bfb64239c120c466424217477' then 'ETH balancer'

when to_address='0x298e0b0a38ff8b99bf1a3b697b0efb2195cfe47d' then 'Drip'

when to_address='0x7b4adf64b0d60ff97d672e473420203d52562a84' then 'USD Coin (USDC)'

when to_address='0x0043d60e87c5dd08c86c3123340705a1556c4719' then 'ETH transferer'

when to_address='0x445fbeb5d895a50bcd6c7e1fa860d014c8244393' then 'NeXT BasE'

else 'Azuland Mint 1' end as contract,

COUNT(*) AS num_transactions,

AVG(tx_fee) AS avg_tx_fee,

MAX(tx_fee) AS max_tx_fee,

MIN(tx_fee) AS min_tx_fee

FROM base.goerli.fact_transactions

WHERE to_address IS NOT NULL

GROUP BY contract

ORDER BY num_transactions DESC

LIMIT 10