count(DISTINCT tx_hash) as sales,

count(DISTINCT SELLER_ADDRESS)as sellers,

count(DISTINCT tokenid) as nfts

from ethereum.core.ez_nft_sales

where NFT_ADDRESS = lower ('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')

and event_type = 'sale'

group by 1)

UNION ALL

(select 'Mint sales' as type,

count(DISTINCT tx_hash) as sales,

count(DISTINCT NFT_TO_ADDRESS) as sellers,

sum(NFT_COUNT) as nfts

from ethereum.core.ez_nft_mints

where NFT_ADDRESS = lower ('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')

and EVENT_TYPE = 'nft_mint'

group by 1)