distinct BUYER as TS_address,

count(TX_ID) as number_bought

from flow.core.fact_nft_sales

where TX_SUCCEEDED='TRUE'

and tx_id is not NULL

group by 1 having number_bought>100)

select

NFT_COLLECTION,

count(distinct buyer) as number_whales

from flow.core.fact_nft_sales

where TX_SUCCEEDED='TRUE'

and tx_id is not NULL

and buyer in (select TS_address from tb1)

group by 1