CASE

WHEN LOWER(contract_address) IN (

'0x4b07f2d19028a7fb7bf5e9258f9666a9673da331',

'0x5656c4972827e93e921bcfe6d60148720fce8b55',

'0xe41572a814d660d13b97d5bd33fbb4850b85b421',

) THEN 'PunchSwap V2'

WHEN LOWER(contract_address) = '0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e' THEN 'Wrapped Flow'

WHEN LOWER(contract_address) = '0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52' THEN 'Bridged USDC (Celer)'

WHEN LOWER(contract_address) = '0x4bd2a1649e5698f97a1ab0515ee407ebc8a3abe7' THEN 'GreenConChicken'

WHEN LOWER(contract_address) = '0x995258cea49c25595cd94407fad9e99b81406a84' THEN 'Avocado'

WHEN LOWER(contract_address) = '0x68eb683a393c8a1c816255b4fc4b89d73c52ad4b' THEN 'pump.flow'

WHEN LOWER(contract_address) = '0xd8ad8ae8375aa31bff541e17dc4b4917014ebdaa' THEN 'BETA'

WHEN LOWER(contract_address) = '0x1b97100ea1d7126c4d60027e231ea4cb25314bdb' THEN 'Ankr Staked FLOW EVM'

ELSE LOWER(contract_address)

END AS contract_name,

COUNT(DISTINCT origin_from_address) AS user_count

FROM flow.core_evm.fact_event_logs

GROUP BY contract_name

ORDER BY user_count DESC

LIMIT 10;