Specterblast bridge 2
Updated 2024-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH Segment AS (
SELECT
decoded_log:user AS wallets,
SUM(decoded_log:amount/pow(10,18)) AS Total_Amount_eth,
CASE
WHEN COUNT(CASE WHEN EVENT_NAME = 'BridgedDeposit' THEN 1 ELSE NULL END) >= 5 THEN 'Frequent User'
WHEN COUNT(CASE WHEN EVENT_NAME = 'BridgedDeposit' THEN 1 ELSE NULL END) >= 2 THEN 'Occasional User'
ELSE 'Infrequent User'
END AS user_segment
FROM
blast.core.ez_decoded_event_logs
WHERE event_name = 'BridgedDeposit'
GROUP BY
wallets
)
SELECT user_segment, COUNT(*) AS TotalTransaction
FROM Segment
GROUP BY user_segment
QueryRunArchived: QueryRun has been archived