WITH RECURSIVE w_total_wallets_with_nft (address) AS
(
SELECT
solana.fact_nft_sales.purchaser
FROM
flipside_prod_db.solana.fact_nft_sales
JOIN flipside_prod_db.solana.dim_labels ON flipside_prod_db.solana.fact_nft_sales.mint = flipside_prod_db.solana.dim_labels.address
WHERE
flipside_prod_db.solana.dim_labels.address_name='genopets token'
AND flipside_prod_db.solana.dim_labels.label='genopets'
GROUP BY solana.fact_nft_sales.purchaser
)
SELECT COUNT (*) AS Total_wallet_with_NFT FROM w_total_wallets_with_nft