-- https://nftevening.com/bubblegoose-ballers-nft-everything-you-need-to-know/
WITH all_bb_nfts AS (
SELECT
address
FROM
solana.core.dim_labels
WHERE
address_name ilike '%bubblegoose%'
)
SELECT
*
FROM
solana.core.fact_nft_sales
WHERE
mint IN (SELECT address FROM all_bb_nfts)