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

and BLOCK_TIMESTAMP>='2022-01-01'

and PRICE>1000

group by 1)

select

CONTRACT_NAME as NFT_project,

count(distinct buyer) as number_whales

from flow.core.fact_nft_sales x join flow.core.dim_contract_labels y on x.NFT_COLLECTION=y.EVENT_CONTRACT

where TX_SUCCEEDED='TRUE'

and tx_id is not NULL

and buyer in (select TS_address from tb1)

group by 1

order by 2 desc

limit 10