SELECT

CASE

WHEN FROM_ADDRESS = LOWER('0x4da27a545c0c5B758a6BA100e3a049001de870f5') THEN TO_ADDRESS

ELSE FROM_ADDRESS

END AS address,

CASE

WHEN FROM_ADDRESS = LOWER('0x4da27a545c0c5B758a6BA100e3a049001de870f5') THEN -1 * CAST(RAW_AMOUNT AS DOUBLE)

ELSE CAST(RAW_AMOUNT AS DOUBLE)

END AS amount

FROM ethereum.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = LOWER('0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9') -- AAVE Token Address

AND (FROM_ADDRESS = LOWER('0x4da27a545c0c5B758a6BA100e3a049001de870f5')

OR TO_ADDRESS = LOWER('0x4da27a545c0c5B758a6BA100e3a049001de870f5'))

),

filtered_stakers AS (

SELECT

address,

SUM(amount / 1e18) AS total_staked

FROM staked_data

GROUP BY address

HAVING SUM(amount / 1e18) > 0 -- Ensure only stakers with positive amounts

SELECT

COUNT(DISTINCT address) AS Total_Stakers

FROM filtered_stakers;