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'

),

addresses AS (

SELECT from_address, min(block_timestamp::date) as first_transaction

FROM ethereum.transactions t

INNER JOIN minters m ON t.from_address = m.minter

GROUP BY from_address

SELECT COUNT(*), first_transaction FROM addresses

GROUP BY 2

ORDER BY 1 DESC