MargielaWhale dominance
    Updated 2024-09-12
    WITH total_volume AS (
    SELECT
    SUM(amount) AS total_volume
    FROM
    sei.nft.ez_nft_sales
    WHERE
    project_name = 'WeBump'
    ),
    top_10_volume AS (
    SELECT
    SUM(amount) AS top_10_volume
    FROM (
    SELECT
    amount
    FROM
    sei.nft.ez_nft_sales
    WHERE
    project_name = 'WeBump'
    ORDER BY
    amount DESC
    LIMIT 10
    ) AS top_10
    ),
    top_100_volume AS (
    SELECT
    SUM(amount) AS top_100_volume
    FROM (
    SELECT
    amount
    FROM
    sei.nft.ez_nft_sales
    WHERE
    project_name = 'WeBump'
    ORDER BY
    amount DESC
    LIMIT 100
    QueryRunArchived: QueryRun has been archived