binhachonAAVE: 17. [Easy] Who is getting Aave Rewards: Group by AAVE claimed
    Updated 2021-10-05
    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