vendettaSELLER_SALES_DISTRIBUTION
Updated 2022-09-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with tab1 as (
select
buyer,
sum(price) as count1
from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id
where team is not null
group by 1 )
select
Case
when count1 between 0 and 100 then 'Between 0 and 100 Flow'
when count1 between 100 and 300 then 'Between 100 and 300 Flow'
when count1 between 300 and 500 then 'Between 300 and 500 Flow'
when count1 between 500 and 1000 then 'Between 500 and 1000 Flow'
when count1 between 1000 and 5000 then 'Between 1000 and 5000 Flow'
else 'Greater Than 5000 Flow'
end as Seller_Sales_Distribution,
count(*)
from tab1
group by 1
Run a query to Download Data