yasminDistribution by Number of Transactions
    Updated 2024-06-09
    WITH
    user_transactions AS (
    SELECT
    seller_address AS user,
    COUNT(DISTINCT tx_hash) AS Sale
    FROM
    near.nft.ez_nft_sales
    WHERE
    block_timestamp::date >= '{{Start_Date}}'
    AND block_timestamp::date <= '{{End_Date}}'
    AND NFT_ADDRESS = '{{project_name}}'
    GROUP BY
    seller_address
    UNION ALL
    SELECT
    buyer_address AS user,
    COUNT(DISTINCT tx_hash) AS Sale
    FROM
    near.nft.ez_nft_sales
    WHERE
    block_timestamp::date >= '{{Start_Date}}'
    AND block_timestamp::date <= '{{End_Date}}'
    AND NFT_ADDRESS = '{{project_name}}'
    GROUP BY
    buyer_address
    )
    SELECT
    CASE
    WHEN Sale = 1 THEN '1 trade'
    WHEN Sale BETWEEN 2 AND 5 THEN '2-5 trades'
    WHEN Sale BETWEEN 6 AND 10 THEN '6-10 trades'
    WHEN Sale BETWEEN 11 AND 20 THEN '11-20 trades'
    WHEN Sale BETWEEN 21 AND 50 THEN '21-50 trades'
    WHEN Sale > 50 THEN '50+ trades'
    END AS user_type,
    COUNT(DISTINCT user) AS user_count
    QueryRunArchived: QueryRun has been archived