fidamDistribution of Buyer by Nft
Updated 2024-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
With Weak AS(
SELECT
BUYER_ADDRESS,
Count(TOKENID) as Nft_sale
From optimism.nft.ez_nft_sales
WHERE PLATFORM_NAME ='element'
Group by BUYER_ADDRESS
)
SELECT
Count(DISTINCT BUYER_ADDRESS) as Buyers,
CASE
When Nft_sale < 10 Then 'Less than 10 Nft'
When Nft_sale BETWEEN 10 AND 15 Then '10 to 15 Nft'
When Nft_sale Between 15 AND 50 Then '15 to 50 NFT'
When Nft_Sale BETWEEN 50 And 100 Then '50 to 100 Nft'
When Nft_sale BETWEEN 100 AND 200 Then '100 to 200 Nft'
When Nft_sale <300 Then 'Above 300 Nft'
End as Sales_Category
From Weak
GROUP by Sales_category
QueryRunArchived: QueryRun has been archived