Query editor
1select 2 collateral_type,3 max_by(interest_rates, (block_number, tx_index)) as interest_rate 4from 5query_63706736where cast(operation as double) = 67group by 1 8order by lower(collateral_type) desc
select
collateral_type,
max_by(interest_rates, (block_number, tx_index)) as interest_rate
from
query_6370673
where cast(operation as double) = 6
group by 1
order by lower(collateral_type) desc