with nfts as (
SELECT * from solana.core.dim_labels
where ADDRESS_NAME = 'bubblegoose ballers'
),
raw as (
SELECT
TX_FROM as address,
AMOUNT * -1 as flow
FROM solana.core.fact_transfers
where mint in (select address from nfts)
union all
select
TX_TO as address,
AMOUNT as flow
FROM solana.core.fact_transfers
where mint in (select address from nfts)
)
select
address,
sum(flow) as holdings
from raw
group by address
having holdings > 0
order by holdings DESC