niloUntitled Query
Updated 2022-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
⌄
WITH
USERS AS (
SELECT BUYER FROM flow.core.ez_nft_sales SALES WHERE NFT_COLLECTION = 'A.329feb3ab062d289.RaceDay_NFT' AND TX_SUCCEEDED = 'TRUE' GROUP BY 1 UNION
SELECT SELLER FROM flow.core.ez_nft_sales SALES WHERE NFT_COLLECTION = 'A.329feb3ab062d289.RaceDay_NFT' AND TX_SUCCEEDED = 'TRUE' GROUP BY 1 ),
FANS AS (SELECT DISTINCT BUYER FROM USERS),
SEL AS (SELECT COUNT (DISTINCT NFT_ID) AS SEL_NFT FROM flow.core.ez_nft_sales WHERE SELLER IN (SELECT BUYER FROM FANS AND TX_SUCCEEDED = 'TRUE')),
BUY AS (SELECT COUNT (DISTINCT NFT_ID) AS bUY_NFT FROM flow.core.ez_nft_sales WHERE BUYER IN (SELECT BUYER FROM FANS AND TX_SUCCEEDED = 'TRUE')
SELECT
SEL_NFT,bUY_NFT,COUNT (DISTINCT BUYER) AS USERS,
bUY_NFT - SEL_NFT AS HOLDS,
HOLDS / USERS AS HOLD_PER_WALLET
FROM BUY,SEL,FANS GROUP BY 1,2
/*
CASE
WHEN NFT = 1 THEN 'Buy only One NFT'
WHEN NFT < 5 THEN 'Less than 5 NFT'
WHEN NFT BETWEEN 5 AND 10 THEN 'Between 5 and 10 NFT'
WHEN NFT BETWEEN 11 AND 50 THEN 'Between 10 and 50 NFT'
WHEN NFT BETWEEN 51 AND 100 THEN 'Between 50 and 100 NFT'
ELSE 'More than 100 NFT' END AS TYPE
*/
Run a query to Download Data