platform,

COUNT(DISTINCT tx_hash) AS liquidation_count,

COUNT(DISTINCT borrower) AS unique_borrowers_liquidated,

COUNT(DISTINCT tx_hash) * 100.0 / SUM(COUNT(DISTINCT tx_hash)) OVER () AS liquidation_percentage

FROM gnosis.defi.ez_lending_liquidations

GROUP BY platform;