Query editor
select'arcade' as protocol,cast(lender as varchar) as lender,sum(amount * price) as od,count(DISTINCT loanId) as loansfrom query_3571586 aleft join query_3675587 p on a.token_contract = p.contract_addresswhere loan_status = 'Active'group by 1,2union allselect'nftfi' as protocol,cast(lender as varchar) as lender,sum(amount * price) as od,count(DISTINCT loanId) as loansfrom query_3669461 aleft join query_3675587 p on a.token_contract = p.contract_addresswhere loan_status = 'Active'group by 1,2union allselect'gondi' as protocol,cast(lender as varchar) as lender,sum(amount * price) as od,count(DISTINCT loanId) as loansfrom query_3532218 aleft join query_3675587 p on a.token_contract = p.contract_addresswhere status = 'Active'group by 1,2union allselect'x2y2' as protocol,cast(lender as varchar) as lender,sum(amount * price) as od,count(DISTINCT loanId) as loansfrom query_3715094 aleft join query_3675587 p on a.token_contract = p.contract_addresswhere loan_status = 'Active'group by 1,2union allselect'zharta' as protocol,cast(lender as varchar) as lender,sum(amount * price) as od,count(DISTINCT loanId) as loansfrom query_3688154 aleft join query_3675587 p on a.token_contract = p.contract_addresswhere loan_status = 'Active'group by 1,2