Query editor
With Dex_metrics AS (selectproject,count (*) as num_trades,sum (amount_usd) as total_volume_usd,avg (amount_usd) as avg_trade_volume_usd,count (distinct token_pair) as num_token_pairsfrom dex.tradeswhere block_time >= current_date - interval '122' dayand blockchain = 'sei'group by project)selectproject,num_trades,total_volume_usd,avg_trade_volume_usd,num_token_pairsfrom dex_metricsorder by total_volume_usd DESClimit 10