flipside

    average price for projects with more than 50 sales
    B09average price for projects with more than 50 sales
    Updated 2024-05-22
    SELECT PROJECT_NAME, AVG(PRICE_USD) AS AveragePrice
    FROM ethereum.nft.ez_nft_sales
    WHERE PROJECT_NAME IN (
    SELECT PROJECT_NAME
    FROM ethereum.nft.ez_nft_sales
    GROUP BY PROJECT_NAME
    HAVING COUNT(*) > 50
    )
    GROUP BY PROJECT_NAME;
    QueryRunArchived: QueryRun has been archived