Query editor
1select 2date_trunc('month', evt_block_time) as month,3sum(loan_duration)/count(*) as avg_duration,4sum(loan_duration * loan_amount_usd)/sum(loan_amount_usd) as weighted_avg_duration5from query_30157486group by 17order by 1 desc
select
date_trunc('month', evt_block_time) as month,
sum(loan_duration)/count(*) as avg_duration,
sum(loan_duration * loan_amount_usd)/sum(loan_amount_usd) as weighted_avg_duration
from query_3015748
group by 1
order by 1 desc