msafadoostUntitled Query
    Updated 2022-06-12
    SELECT
    DISTINCT(BUYER) as t_s_buers,
    CASE
    WHEN COUNT(BUYER) >= '1000' THEN '> 1000'
    WHEN COUNT(BUYER) < '1000' AND COUNT(BUYER) >= '500' THEN '1000 < and <= 500'
    ELSE '500 <' END as Number_of_buy
    FROM flow.core.fact_nft_sales
    WHERE marketplace = 'A.0b2a3299cc857e29.TopShot' OR
    marketplace = 'A.c1e4f4f4c4257510.TopShotMarketV3'
    GROUP BY 1
    ORDER by 2 DESC
    Run a query to Download Data