binhachonAAVE: 17. [Easy] Who is getting Aave Rewards: Group by AAVE claimed
Updated 2021-10-05
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
›
⌄
SELECT CASE
WHEN AAVE_AMOUNT < 10 THEN '1. Less than 10 AAVE claimed'
WHEN 100 > AAVE_AMOUNT >= 10 THEN '2. 10-100 AAVE claimed'
WHEN 1000 > AAVE_AMOUNT >= 100 THEN '3. 100 - 1000 AAVE claimed'
WHEN 10000 > AAVE_AMOUNT >= 1000 THEN '4. 1000 - 10000 AAVE claimed'
ELSE '5. Over 10000 AAVE claimed' END AS CATEGORY,
SYMBOL,
SUM(AAVE_AMOUNT) AS AAVE_AMOUNT,
COUNT(ORIGIN_ADDRESS)
FROM
((
SELECT 'LENDING_BORROWING' AS SYMBOL, ORIGIN_ADDRESS, SUM(AMOUNT) as AAVE_AMOUNT FROM ethereum.udm_events
WHERE FROM_ADDRESS = '0xd784927ff2f95ba542bfc824c8a8a98f3495f6b5'
AND ORIGIN_FUNCTION_SIGNATURE = '0x3111e7b3'
AND CONTRACT_ADDRESS = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'
GROUP BY SYMBOL, ORIGIN_ADDRESS
) UNION ALL
(SELECT 'stkAAVE_stkABPT' as SYMBOL, ORIGIN_ADDRESS, SUM(AMOUNT) AS AAVE_AMOUNT FROM ethereum.udm_events
WHERE FROM_ADDRESS = '0x25f2226b597e8f9514b3f68f00f494cf4f286491'
AND ORIGIN_FUNCTION_SIGNATURE = '0x9a99b4f0'
GROUP BY SYMBOL, ORIGIN_ADDRESS
))
GROUP BY CATEGORY, SYMBOL
ORDER BY AAVE_AMOUNT DESC
Run a query to Download Data