feyikemiClayno_Purchasers
    Updated 2024-03-12
    SELECT
    -- Block_timestamp :: date as date,
    COUNT(DISTINCT purchaser) AS Purchasers

    FROM solana.nft.fact_nft_mints m
    LEFT JOIN solana.nft.dim_nft_metadata l
    ON m.mint = l.mint

    WHERE NFT_Name LIKE '%Clayno%'
    AND Block_timestamp >= '2024-01-01'


    -- GROUP BY 1

    -- ORDER BY 2 DESC


    QueryRunArchived: QueryRun has been archived