SELECT

COUNT(DISTINCT DEPOSITOR) AS Total_Depositors

FROM

avalanche.defi.ez_lending_deposits

WHERE

PLATFORM = 'Benqi'

AND block_timestamp >= '2024-01-01'

),

Total_Depositors_August AS (

SELECT

COUNT(DISTINCT DEPOSITOR) AS Total_Depositors_August

FROM

avalanche.defi.ez_lending_deposits

WHERE

PLATFORM = 'Benqi'

AND block_timestamp::date BETWEEN '2024-08-01' AND '2024-08-31'

),

Total_Depositors_Past_24H AS (

SELECT

COUNT(DISTINCT DEPOSITOR) AS Total_Depositors_Past_24H

FROM

avalanche.defi.ez_lending_deposits

WHERE

PLATFORM = 'Benqi'

AND block_timestamp >= current_date - INTERVAL '1 day'

SELECT

Total_Depositors,

Total_Depositors_August,

Total_Depositors_Past_24H

FROM

Total_Depositors, Total_Depositors_August, Total_Depositors_Past_24H;