with contractt as (

select

address,

symbol,

from monad.testnet.dim_contracts

select

case when tx_rank <= 8 then label else 'other' end as contract_tx,

case when user_rank <= 8 then label else 'other' end as contract_user,

case when fee_rank <= 8 then label else 'other' end as contract_fee,

select

distinct contract_address,

case

when contract_address = '0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7' then 'Pump4gains'

when contract_address = '0x8462c247356d7deb7e26160dbfab16b351eef242' then 'Wrapping and Unwrapping Monad'

when contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' then 'Wrapped Monad (WMON)'

when contract_address = '0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0' then 'Uniswap'

when contract_address = '0xca810d095e90daae6e867c19df6d9a8c56db2c89' then 'Bean DEX'

when contract_address = '0xb33d7138c53e516871977094b249c8f2ab89a4f4' then 'OPEN EDITION CHOGSTAR'

when contract_address = '0xbb444821e159dd6401bb92fb18c2ac0a37113025' then 'FANTASY USD'

when contract_address = '0xb2f82d0f38dc453d596ad40a37799446cc89274a' then 'aPriori Monad LST'

when contract_address = '0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba' then 'EMMY ON MONAD'

when contract_address = '0x758d80767a751fc1634f579d76e1ccaab3485c9c' then 'Nad Name Service'

when contract_address = '0x836047a99e11f376522b447bffb6e3495dd0637c' then 'ETH'

when contract_address = '0x436ee7219bb099f71c9db9c7de8862a9bde891ae' then 'Monad x Alchemy'

when contract_address = '0xc816865f172d640d93712c68a7e1f83f3fa63235' then 'Kuru'

when contract_address = '0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfd' then 'IZUMI Swap'