theericstonescores vs spend
Updated 2024-09-16
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
31
32
33
34
35
36
›
⌄
-- Example query in Snowflake to produce the given dataset
WITH Data AS (
SELECT
1 AS SCORE, 1000000 AS Addresses, 100 AS Typical_On_Chain_Spend
UNION ALL
SELECT
2 AS Score, 600000 AS Addresses, 150 AS Typical_On_Chain_Spend
UNION ALL
SELECT
3 AS Score, 100000 AS Addresses, 175 AS Typical_On_Chain_Spend
UNION ALL
SELECT
4 AS Score, 80000 AS Addresses, 400 AS Typical_On_Chain_Spend
UNION ALL
SELECT
5 AS Score, 65000 AS Addresses, 800 AS Typical_On_Chain_Spend
UNION ALL
SELECT
6 AS Score, 40000 AS Addresses, 1300 AS Typical_On_Chain_Spend
UNION ALL
SELECT
7 AS Score, 30000 AS Addresses, 10000 AS Typical_On_Chain_Spend
UNION ALL
SELECT
8 AS Score, 20000 AS Addresses, 19000 AS Typical_On_Chain_Spend
UNION ALL
SELECT
9 AS Score, 15000 AS Addresses, 30000 AS Typical_On_Chain_Spend
UNION ALL
SELECT
10 AS Score, 10000 AS Addresses, 50000 AS Typical_On_Chain_Spend
UNION ALL
SELECT
11 AS Score, 7000 AS Addresses, 80000 AS Typical_On_Chain_Spend
UNION ALL
SELECT
QueryRunArchived: QueryRun has been archived