case when nft_address = '0x81b30ff521d1feb67ede32db726d95714eb00637' then 'Optimistic Explorer'

when nft_address = '0xa95579592078783b409803ddc75bb402c217a924' then 'Optimism Collective: Hello World'

when nft_address = '0x69a68eb548a37ee475d9f89646945588558796d1' then 'Oliens'

when nft_address = '0xb91b2276bd5a98994bf1f496e3886f688f8d4581' then 'Kasou-shin Genesis NFTs'

when nft_address = '0xbe81eabdbd437cba43e4c1c330c63022772c2520' then 'unknown'

when nft_address = '0xdbfeaae58b6da8901a8a40ba0712beb2ee18368e' then 'Dope Wars Hustlers'

when nft_address = '0x8e56343adafa62dac9c9a8ac8c742851b0fb8b03' then 'Bored Town'

when nft_address = '0xa698713a3bc386970cdc95a720b5754cc0f96931' then 'Words (viaMirror)'

when nft_address = '0xc36442b4a4522e871399cd717abdd847ab11fe88' then 'Uniswap V3 Positions'

when nft_address = '0xe0a3711d4286e628998d47bef524c292defd1719' then 'Holo Mask : White & Black' else 'others' end as collection,

count(*)

from optimism.core.ez_nft_sales

where

platform_address in ('0x20975da6eb930d592b9d78f451a9156db5e4c77b', '0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6', '0x3f9da045b0f77d707ea4061110339c4ea8ecfa70') and

event_type = 'sale'

group by 1

order by 2 desc