msafadoostUntitled Query
Updated 2022-06-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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