0xtoshicountAge
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,
DATEDIFF('day', min(SOURCE_TIMESTAMP_UTC), '2024-05-01 23:59:59') as age
FROM external.layerzero.fact_transactions_snapshot
GROUP BY 1
),
Counting as (
SELECT age,
COUNT(SENDER_WALLET) as total_address
FROM LZAGE
GROUP BY 1
)
SELECT
CASE
WHEN AGE BETWEEN 0 AND 100 THEN '0-100'
WHEN AGE BETWEEN 101 AND 200 THEN '100-200'
WHEN AGE BETWEEN 201 AND 300 THEN '201-300'
WHEN AGE BETWEEN 301 AND 400 THEN '301-400'
WHEN AGE BETWEEN 401 AND 500 THEN '401-500'
WHEN AGE BETWEEN 501 AND 600 THEN '501-600'
WHEN AGE BETWEEN 601 AND 700 THEN '601-700'
WHEN AGE BETWEEN 701 AND 800 THEN '701-800'
WHEN AGE BETWEEN 801 AND 900 THEN '801-900'
WHEN AGE BETWEEN 901 AND 1000 THEN '901-1000'
ELSE '>1000'
END AS age_range,
SUM(total_address) AS total_address
FROM Counting
GROUP BY 1
QueryRunArchived: QueryRun has been archived