Query editor
with data as (select nft_collection_name,count(distinct unique_id) as od_loans,sum(amount * price) as outstanding_debt_usdfrom query_3715978 left join query_3675587 p on p.contract_address = token_contractwhere loan_status = 'Active'group by 1),df as (SELECTnft_collection_name,ROW_NUMBER() OVER (ORDER BY outstanding_debt_usd DESC) AS _row,outstanding_debt_usdFROM data)selectcase when _row < 15 then nft_collection_name else 'Other' end as nft_collection_name,sum(outstanding_debt_usd) as outstanding_debt_usdFROM dfGROUP BY 1order by outstanding_debt_usd DESC/*with week_end_dates as (select date_add('day', (row_number() over() - 1) * -7, date_trunc('week', now())) as datefrom ens.reverse_latestwhere latest_tx_block_time >= CAST('2020-05-01' AS TIMESTAMP)),loan_start as (SELECTloan_amount_usd,loan_amount_original,loan_token_address,loan_token_symbol,evt_block_time as day,unique_id, nft_collection_name as name, collateral_contract, collateral_id,(date_add('day', CAST(loan_duration as BIGINT), evt_block_time)) as maturityFROMquery_3835468),loans_reneg as (SELECT-loan_amount_usd as loan_amount_usd,evt_block_time as day,unique_id,date_add('day', CAST(loan_duration as BIGINT), loan_start_time) as maturity,ROW_NUMBER() OVER (PARTITION BY CONCAT(loan_id, CAST(contract_address as VARCHAR)) ORDER BY evt_block_time DESC) as rnFROMquery_3715138),loans_ended as (SELECT-loan_amount_usd as loan_amount_usd,evt_block_time as day,unique_idFROMquery_3715145