Query editor
with seven_day_volume as (select project,sum(amount_usd) as usd_volumefrom dex.tradeswhere block_time > now() - interval '7' daygroup by 1),one_day_volume as (select project, sum(amount_usd) as usd_volumefrom dex.tradeswhere block_time > now() - interval '1' daygroup by 1)select row_number() over (order by sum(seven.usd_volume) desc nulls first) as ranks,seven.project,sum(seven.usd_volume) as "7 days volume",sum(one.usd_volume) as "24 hours volume"from seven_day_volume as sevenleft join one_day_volume as one on seven.project = one.projectwhere not seven.usd_volume is nullgroup by 2order by 3 desc nulls first