select case when address = '0x0110bb5739a6f82eafc748418e572fc67d854a0f' then 'Early Optimists'

when address = '0x81b30ff521d1feb67ede32db726d95714eb00637' then 'Optimistic Explorer'

when address ='0xdbfeaae58b6da8901a8a40ba0712beb2ee18368e' then 'Hustlers'

when address ='0xa95579592078783b409803ddc75bb402c217a924' then 'Optimism collective'

when address ='0xbf2794adaf7a48a2a24eb344a7ba221a52fe2171' then 'OP Orcas'

when address = '0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2' then 'PROJECT GALAXY'

when address = '0x5dab03f63a5108869dd90b8092bfb98fb6e84102' then 'Ugliest Demon'

else upper(ADDRESS_NAME)

end collection_name ,

address NFT_ADDRESS

from optimism.core.dim_labels

group by 1 ,2

),

Top_5 as (

select collection_name ,

NFT_ADDRESS ,

sum (price_usd) volume

from optimism.core.ez_nft_sales join Collections using (NFT_ADDRESS)

group by 1,2 order by volume desc limit 5

),

Top_5collections_purchasers as (

select

BUYER_ADDRESS ,

count (DISTINCT collection_name) num_crossover

from optimism.core.ez_nft_sales join Collections using (NFT_ADDRESS)

where NFT_ADDRESS in (select NFT_ADDRESS from Top_5 )

group by 1

select

case when num_crossover = 1 then 'crossover with one of Top 5 NFT projects'

when num_crossover = 2 then 'crossover with 2 of Top 5 NFT projects'

when num_crossover = 3 then 'crossover with 3 of Top 5 NFT projects'

when num_crossover = 4 then 'crossover with 4 of Top 5 NFT projects'

when num_crossover = 5 then 'crossover with 5 of Top 5 NFT projects'

end as range ,