Query editor
SELECT*,(SELECT AVG(loan_duration) FROM query_3015748) as loan_durationFROM(SELECTdate_trunc('month', evt_block_time) as month,SUM(loan_amount_usd) as volume_usd,AVG(loan_amount_usd) as avg_usd,SUM(loan_amount_eth) as volume_eth,COUNT(*) as number_loans,COUNT(DISTINCT borrower) AS borrowers,COUNT(DISTINCT lender) AS lenders,MAX(loan_amount_usd) as max_usdFROMquery_3015748GROUP BY 1)ORDER BY month DESC