select nft_to_address,

event_type,

case mint_price_eth

when 0 then 'Freebie'

when 0.1 then 'Allow list'

else 'Monster'

end as minter_type

from ethereum.core.ez_nft_mints

where nft_address = lower('0x903E2F5d42EE23156D548DD46bb84B7873789E44')

and block_timestamp < '2022-06-07 17:00:00'

order by block_timestamp)

select minter_type,

count (nft_to_address)

from early_minter

group by 1