--farokh
with popular
as (select
purchaser,
sum(sales_amount) as sale_amount
from
solana.fact_nft_sales
where succeeded='TRUE'
group by 1
having sale_amount>500
)
select
case
when signers[0] in
(select purchaser
from popular) then 'Whale'
else 'Fish' end as users,
count(distinct signers[0]) as users_unique
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'
group by 1