SELECT

depositor AS address,

SUM(d.amount_usd) AS "total deposited usd"

FROM

gnosis.defi.ez_lending_deposits d

WHERE

d.amount_usd IS NOT NULL

GROUP BY

depositor

),

Withdrawn AS (

SELECT

depositor AS address,

SUM(w.amount_usd) AS "total withdrawn usd"

FROM

gnosis.defi.ez_lending_withdraws w

WHERE

w.amount_usd IS NOT NULL

GROUP BY

depositor

),

Borrowed AS (

SELECT

borrower AS address,

SUM(b.amount_usd) AS "total borrowed usd"

FROM

gnosis.defi.ez_lending_borrows b

WHERE

b.amount_usd IS NOT NULL

GROUP BY

borrower

),

Repaid AS (

SELECT

payer AS address,