dethective[PEW] Deposit by size
Updated 2024-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
category, COUNT(*) as n_depositors
FROM
(
SELECT
block_timestamp,
amount,
CASE
WHEN amount <= 1 THEN 'poor'
WHEN amount > 1
AND amount <= 2 THEN 'wannabe'
WHEN amount > 2 THEN 'pewpew'
END AS category
FROM
blast.core.ez_native_transfers
WHERE
to_address = '0x0ee485dfd0f4ef8c4fabc1ab93dbcc03fcc05c57'
)
GROUP BY category
QueryRunArchived: QueryRun has been archived