select

distinct buyer

from flow.core.fact_nft_sales

where split(nft_collection,'.')[2] like '%TopShot%'

select

split(nft_collection,'.')[2],

sum(price),

count(*)

from flow.core.fact_nft_sales

where split(nft_collection,'.')[2] not like '%TopShot%'

and buyer in (select * from m)

group by 1