select nft_to_address as addr

from ethereum.core.ez_nft_mints

where block_timestamp between '2022-06-07 16:00:00.000' and '2022-06-07 17:00:00.000' and nft_address = '0x903e2f5d42ee23156d548dd46bb84b7873789e44' and

nft_from_address = '0x0000000000000000000000000000000000000000' and event_type = 'nft_mint'

group by 1

),

all_wallet as (

select count(distinct addr) as all_wallet

from addr

),

buy as (

select count(distinct addr) as buy_number, 'bought NFT before' as type

from addr, ethereum.core.ez_nft_sales

where addr = buyer_address and project_name is not null

),

no_buy as (

select all_wallet - buy_number as no_buy_number

from all_wallet, buy

select buy_number as number, 'bought NFT before' as type

from buy

union all

select no_buy_number as number, 'didnt bought NFT before' as type

from no_buy