Query editor
WITH ranked AS (SELECT projectFROM lending.borrowWHERE block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '1' MONTH)AND block_time >= CURRENT_DATE - INTERVAL '30' DAYAND blockchain IN ('ethereum','arbitrum','optimism','base','polygon','scroll','zksync','linea')AND transaction_type = 'borrow'GROUP BY projectORDER BY COUNT(DISTINCT borrower) DESCLIMIT 5)SELECTb.project,b.blockchain,COUNT(DISTINCT b.borrower) AS unique_borrowers,COUNT(*) AS borrow_txns,SUM(COALESCE(b.amount_usd, 0)) AS borrow_volume_usdFROM lending.borrow bJOIN ranked r ON b.project = r.projectWHERE b.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '1' MONTH)AND b.block_time >= CURRENT_DATE - INTERVAL '30' DAYAND b.transaction_type = 'borrow'AND b.blockchain IN ('ethereum','arbitrum','optimism','base','polygon','scroll','zksync','linea')GROUP BY b.project, b.blockchainORDER BY unique_borrowers DESC