payer,

SUM(amount_usd) AS "total repaid(usd)",

COUNT(tx_hash) AS "repayment count"

FROM gnosis.defi.ez_lending_repayments

WHERE amount_usd IS NOT NULL

GROUP BY payer

ORDER BY "total repaid(usd)" DESC

LIMIT 10;