Query editor
SELECTnft_collection_name as "Collection",count(distinct case when loan_status = 'Active' then unique_id end) as "Active Loans",sum(case when loan_status = 'Active' then amount end * p.price) as "Outstanding Debt",avg(loan_amount_usd) as "Average Principal",avg(duration) as "Average Duration",avg(cast(apr as real)/100) as "Average APR"from query_3669461 left join query_3675587 p on token_contract = p.contract_addressgroup by 1order by 3 desc