select

NFT_TO_ADDRESS as Minter

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'

and mint_price_eth!=0

select

-- monthname(date_trunc(month, block_timestamp)) as monthly

buyer_address

,count(distinct tx_hash) as nft_count

,sum(price_usd) as sum_usd

from ethereum.core.ez_nft_sales

where block_timestamp::date>=CURRENT_DATE-180

and buyer_address in(select minter from lst_minter)

group by 1

order by nft_count DESC