distinct nft_address ,

case

when project_name = '0x80336ad7a747236ef41f47ed2c7641828a480baa' then 'Chimpers'

when project_name = '0x9690b63eb85467be5267a3603f770589ab12dc95' then 'ForgottenRunesWarriorsGuild'

when project_name = '0x10cdcb5a80e888ec9e9154439e86b911f684da7b' then 'FVCK_AVATAR'

when project_name = '0x91680cf5f9071cafae21b90ebf2c9cc9e480fb93' then 'frank'

when project_name = '0x5a0d4479aed030305a36a1fb516346d533e794fb' then 'Moshi Mochi'

when project_name = '0x5eaeadda470245343249452e744e423f489abbc4' then 'Elftown.wtf'

when project_name = '0x2ca113e1aa37d83662a1d3f84e209f7068700fa6' then 'Crecodiles'

when project_name = '0x03b8d129a8f6dc62a797b59aa5eebb11ad63dada' then 'SMOWL'

when project_name = '0xafef885027a59603dff7837c280dad772c476b82' then 'omgkirby'

else project_name

end as project_name,

sum(price_usd),

count(distinct tx_hash) as Transactions

from ethereum.core.ez_nft_sales

where platform_name ilike '%nftx%' AND block_timestamp::date >= CURRENT_DATE - 60

group by 1, 2

order by 3 DESC

limit 3