purchaser,

sum(sales_amount) as volume_sale

from solana.fact_nft_sales

where succeeded='TRUE'

group by 1 having volume_sale>500

case

when signers[0] in (select purchaser from whale) then 'Whale'

else 'Fish' end as users,

count(distinct signers[0]) as unique_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 POST_TOKEN_BALANCES[0]:owner='ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'

and block_timestamp>='2022-04-17'

group by 1