msafadoostpersent of wallets sold their NFT
    Updated 2022-06-13
    WITH buyer AS (
    SELECT BUYER as buy,
    NFT_ID AS id
    FROM flow.core.fact_nft_sales
    GROUP BY 1,2
    ),
    COUNTe AS (
    SELECT COUNT(buy) AS buyer_count
    FROM buyer
    ),
    seller AS (
    SELECT COUNT(SELLER) AS seller_count
    FROM flow.core.fact_nft_sales JOIN buyer ON SELLER = buy AND NFT_ID = id
    )
    SELECT (seller_count*100)/buyer_count
    FROM COUNTe FULL JOIN seller
    Run a query to Download Data