distinct BUYER_ADDRESS as TS_address,

count(TX_HASH) as number_bought

FROM ethereum.core.ez_nft_sales

where BLOCK_TIMESTAMP>='2022-01-01'

and PRICE_USD>10000

group by 1)

select

Label as NFT_project,

count(distinct BUYER_ADDRESS) as number_whales

from ethereum.core.ez_nft_sales x join ethereum.core.dim_labels y on x.NFT_ADDRESS=y.ADDRESS

where TX_HASH is not NULL

and BUYER_ADDRESS in (select TS_address from tb1)

group by 1

order by 2 desc

limit 10