shreexWallets Who Have Never Bought A NFT In Solana
    Updated 2022-06-24
    with wallets as (
    select
    inner_instruction:instructions[1]:parsed:info:authority as wallets_preordered
    from solana.core.fact_events where program_id='781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy' and succeeded='TRUE'
    and block_timestamp>= '2022-06-23'

    )
    select

    count(wallets_preordered) as wallet_who_have_never_bought_a_nft_in_solana
    from wallets where wallets_preordered not in (
    select distinct purchaser
    from
    solana.core.fact_nft_sales
    )


    Run a query to Download Data