re_annRepeat buyers analysis
Updated 2024-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH BuyerPurchases AS (
SELECT
buyer_address,
project_name,
COUNT(*) AS num_purchases
FROM base.nft.ez_nft_sales
WHERE event_type = 'sale'
GROUP BY buyer_address, project_name
)
SELECT
project_name,
buyer_address,
num_purchases
FROM BuyerPurchases
WHERE num_purchases > 1 AND project_name is NOT NULL
ORDER BY num_purchases DESC
LIMIT 5;
QueryRunArchived: QueryRun has been archived