ErsvanF - Genopets Staking - Total wallet with NFT
    Updated 2022-05-31
    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
    Run a query to Download Data