ErsvanNFT wallets table
    Updated 2022-05-31
    WITH RECURSIVE w_address_staking (address,Total) AS
    (
    SELECT
    SIGNERS[0]::string AS address,
    COUNT(*)
    FROM
    flipside_prod_db.solana.FACT_TRANSACTIONS
    WHERE
    INSTRUCTIONS[0]:programId = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    AND LOG_MESSAGES[1] = 'Program log: Instruction: Stake'
    GROUP BY address
    ),

    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
    ),

    w_table_wallets_with_nft (state,total) AS
    (
    SELECT 'Total wallet with NFT' AS total_state, COUNT(*) AS total FROM (
    SELECT address FROM w_total_wallets_with_nft
    )
    UNION ALL
    Run a query to Download Data