Count(DISTINCT depositor_address) AS no_of_users,

Round(Sum(supplied_usd), 2) AS tot_aave_supplied_usd,

Count(DISTINCT tx_id) AS no_of_supply_txns

FROM flipside_prod_db.aave.Deposits

WHERE symbol LIKE 'AAVE'

and block_timestamp >= dateadd(month, -12, getdate())

GROUP BY day

ORDER BY day DESC