with Sold as
(select
distinct pre_token_balances[0]:mint as auroian,
signers[0] as users
from solana.fact_transactions
where pre_token_balances[0]:mint
in (
select mint
from solana.dim_nft_metadata
where CONTRACT_NAME='Aurory')
and
instructions[0]:programId='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J'
and
pre_TOKEN_BALANCES[0]:owner='ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'
and
block_timestamp>='2022-04-17')
select
count(mint) as sale_not
from solana.fact_nft_sales
where mint in (
select auroian
from sold)
and purchaser in (
select users
from sold)