0xtoshi2024-06-03 08:52 AM
Updated 2024-06-03
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
›
⌄
WITH LZAGE as (
SELECT SENDER_WALLET,
COUNT(SOURCE_TRANSACTION_HASH) as txCount,
FROM external.layerzero.fact_transactions_snapshot
GROUP BY 1
),
Counting as (
SELECT txCount,
COUNT(SENDER_WALLET) as total_address
FROM LZAGE
GROUP BY 1
)
SELECT
CASE
WHEN txCount BETWEEN 0 AND 100 THEN '0-100'
WHEN txCount BETWEEN 101 AND 200 THEN '100-200'
WHEN txCount BETWEEN 201 AND 300 THEN '201-300'
WHEN txCount BETWEEN 301 AND 400 THEN '301-400'
WHEN txCount BETWEEN 401 AND 500 THEN '401-500'
WHEN txCount BETWEEN 501 AND 600 THEN '501-600'
WHEN txCount BETWEEN 601 AND 700 THEN '601-700'
WHEN txCount BETWEEN 701 AND 800 THEN '701-800'
WHEN txCount BETWEEN 801 AND 900 THEN '801-900'
WHEN txCount BETWEEN 901 AND 1000 THEN '901-1000'
ELSE '>1000'
END AS tx_range,
SUM(total_address) AS total_address
FROM Counting
GROUP BY 1
QueryRunArchived: QueryRun has been archived