flipside

    average USD price of sales per project with an average price over $1000
    B09average USD price of sales per project with an average price over $1000
    Updated 2023-11-16

    WITH AveragePricePerProject AS (
    SELECT PROJECT_NAME, AVG(PRICE_USD) AS AvgPrice
    FROM ethereum.nft.ez_nft_sales
    WHERE nft_address = lower('0x4cd0ea8b1bdb5ab9249d96ccf3d8a0d3ada2bc76')
    GROUP BY PROJECT_NAME
    )
    SELECT PROJECT_NAME, AvgPrice
    FROM AveragePricePerProject
    WHERE
    AvgPrice > 1000
    LIMIT 10;