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 no_sale

from solana.fact_nft_sales

where mint in (select auroian from t1)

and purchaser in (select users from t1)

and block_timestamp>='2022-04-17'