SELECT distinct NFT_TO_ADDRESS as minter

FROM ethereum.core.ez_nft_mints

WHERE NFT_ADDRESS = LOWER('0x903E2F5d42EE23156D548DD46bb84B7873789E44')

AND BLOCK_TIMESTAMP < '2022-06-07 17:00:00.000'

),

buyers AS (

select buyer_address

from ethereum.core.ez_nft_sales

where block_timestamp::date >= '2022-01-01' and buyer_address in (select minter from minters)

SELECT COUNT(TX_HASH), buyer_address FROM ethereum.core.ez_nft_sales

WHERE buyer_address IN (SELECT * FROM buyers)

AND EVENT_TYPE = 'sale'

GROUP BY 2

ORDER BY 1 DESC