vendettaThe total volume of sales of users
    Updated 2024-10-06
    WITH user_sales_volume AS (
    SELECT
    ORIGIN_FROM_ADDRESS,
    SUM(PRICE_USD) AS total_sales_volume
    FROM
    base.nft.ez_nft_sales
    GROUP BY ORIGIN_FROM_ADDRESS
    )
    SELECT
    ORIGIN_FROM_ADDRESS,
    total_sales_volume
    FROM
    user_sales_volume
    ORDER BY total_sales_volume DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived