top_shot_buyer as (

select distinct buyer as t_buyer

from flow.core.fact_nft_sales

where nft_collection = 'A.0b2a3299cc857e29.TopShot'

and block_timestamp > '2022-05-09'

),

ufc_buyer as (

select distinct buyer as u_buyer

from flow.core.fact_nft_sales

where nft_collection = 'A.329feb3ab062d289.UFC_NFT'

and block_timestamp > '2022-05-09'

),

allday_buyer as (

select distinct buyer as all_buyer

from flow.core.fact_nft_sales

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and block_timestamp > '2022-05-09'

)

select count(t.t_buyer) as count, 'TopShot & UFC Shared Buyers' as label

from top_shot_buyer t

inner join ufc_buyer u on u.u_buyer = t.t_buyer

union

select count(t.t_buyer) as count, 'TopShot & AllDay Shared Buyers' as label

from top_shot_buyer t

inner join allday_buyer a on a.all_buyer = t.t_buyer

union

select count(a.all_buyer) as count, 'AllDay & UFC Shared Buyers' as label

from allday_buyer a

inner join ufc_buyer u on u.u_buyer = a.all_buyer