Query editor
WITH loan_patterns AS (SELECT"from" as borrower,MAX(block_time) as last_activity,COUNT(*) as tx_count,SUM(value / 1e18) as total_borrowed,AVG(value / 1e18) as avg_loan_size,MAX(value / 1e18) as max_loan_sizeFROM ethereum.transactionsWHERE block_time >= now() - interval '7' dayAND value / 1e18 >= 10AND success = trueGROUP BY "from"),default_risk AS (SELECTborrower,last_activity,tx_count,total_borrowed,avg_loan_size,max_loan_size,CASEWHEN last_activity < now() - interval '3' day THEN 'High Risk'WHEN last_activity < now() - interval '1' day THEN 'Medium Risk'ELSE 'Low Risk'END as risk_levelFROM loan_patternsWHERE total_borrowed >= 20)SELECTborrower,ROUND(total_borrowed, 2) as total_borrowed_eth,ROUND(avg_loan_size, 2) as avg_loan_size_eth,ROUND(max_loan_size, 2) as max_loan_size_eth,last_activity,risk_levelFROM default_riskWHERE risk_level != 'Low Risk'ORDER BYCASEWHEN risk_level = 'High Risk' THEN 1WHEN risk_level = 'Medium Risk' THEN 2END,total_borrowed DESCLIMIT 30;