feyikemisurprising-bronze
Updated 2024-11-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH veOLAS_Holder_Locks AS (
SELECT
ACCOUNT_ADDRESS,
SUM(OLAS_AMOUNT) AS Total_Locked_OLAS
FROM crosschain.olas.ez_olas_locking
WHERE UNLOCK_TIMESTAMP > CURRENT_TIMESTAMP
GROUP BY ACCOUNT_ADDRESS
)
SELECT
CASE
WHEN Total_Locked_OLAS <= 10000 THEN 'Small Holders'
WHEN Total_Locked_OLAS BETWEEN 10001 AND 100000 THEN 'Medium Holders'
ELSE 'Large Holders'
END AS "Holders Tier",
COUNT(ACCOUNT_ADDRESS) AS "Number of Holders",
SUM(Total_Locked_OLAS) AS "Total Locked OLAS"
FROM veOLAS_Holder_Locks
GROUP BY "Holders Tier"
ORDER BY "Total Locked OLAS" DESC
QueryRunArchived: QueryRun has been archived