NUM_DEX_USED | USERS_COUNT | |
|---|---|---|
1 | 1 | 46186 |
2 | 2 | 969 |
3 | 3 | 194 |
jackguyss 77
Updated 2024-01-30
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
›
⌄
-- Step 1: Get unique SWAPPER and platform combinations
WITH unique_swapper_platform AS (
SELECT DISTINCT
SWAPPER,
platform
FROM sei.defi.fact_dex_swaps
),
-- Step 2: Count the number of unique platforms for each SWAPPER
user_dex_count AS (
SELECT
SWAPPER,
COUNT(platform) AS num_dex_used
FROM unique_swapper_platform
GROUP BY SWAPPER
),
-- Step 3: Count the number of users for each number of platforms used
users_by_dex_count AS (
SELECT
num_dex_used,
COUNT(*) AS users_count
FROM user_dex_count
GROUP BY num_dex_used
)
-- Final Output: Display the number of users for each number of DEXs used
SELECT
num_dex_used,
users_count
FROM users_by_dex_count
ORDER BY num_dex_used;
Last run: about 1 year agoAuto-refreshes every 6 hours
3
27B
4s