niloUntitled Query
    Updated 2022-10-23
    WITH
    USERS AS (
    SELECT BUYER FROM flow.core.ez_nft_sales SALES WHERE NFT_COLLECTION = 'A.329feb3ab062d289.RaceDay_NFT' AND TX_SUCCEEDED = 'TRUE' GROUP BY 1 UNION
    SELECT SELLER FROM flow.core.ez_nft_sales SALES WHERE NFT_COLLECTION = 'A.329feb3ab062d289.RaceDay_NFT' AND TX_SUCCEEDED = 'TRUE' GROUP BY 1 ),

    FANS AS (SELECT DISTINCT BUYER FROM USERS),

    SEL AS (SELECT COUNT (DISTINCT NFT_ID) AS SEL_NFT FROM flow.core.ez_nft_sales WHERE SELLER IN (SELECT BUYER FROM FANS AND TX_SUCCEEDED = 'TRUE')),

    BUY AS (SELECT COUNT (DISTINCT NFT_ID) AS bUY_NFT FROM flow.core.ez_nft_sales WHERE BUYER IN (SELECT BUYER FROM FANS AND TX_SUCCEEDED = 'TRUE')

    SELECT

    SEL_NFT,bUY_NFT,COUNT (DISTINCT BUYER) AS USERS,
    bUY_NFT - SEL_NFT AS HOLDS,
    HOLDS / USERS AS HOLD_PER_WALLET
    FROM BUY,SEL,FANS GROUP BY 1,2

    /*
    CASE
    WHEN NFT = 1 THEN 'Buy only One NFT'
    WHEN NFT < 5 THEN 'Less than 5 NFT'
    WHEN NFT BETWEEN 5 AND 10 THEN 'Between 5 and 10 NFT'
    WHEN NFT BETWEEN 11 AND 50 THEN 'Between 10 and 50 NFT'
    WHEN NFT BETWEEN 51 AND 100 THEN 'Between 50 and 100 NFT'
    ELSE 'More than 100 NFT' END AS TYPE

    */

    Run a query to Download Data