SELECT

borrower AS "Borrower",

COUNT(DISTINCT tx_hash) AS "Total Borrow Transactions",

SUM(amount_usd) AS "Total Borrowed Volume (USD)"

FROM gnosis.defi.ez_lending_borrows

GROUP BY borrower

SELECT

SUM("Total Borrow Transactions") AS "Total Borrow Transactions",

SUM("Total Borrowed Volume (USD)") AS "Total Borrowed Volume (USD)",

COUNT(DISTINCT "Borrower") AS "Total Unique Borrowers",

AVG("Total Borrowed Volume (USD)") AS "Average Borrowed Volume per Borrower (USD)"

FROM borrower_stats;