Query editor
WITH stable_trades AS (SELECTSUM(amount_usd) AS stable_volumeFROM dex.tradesWHERE blockchain = 'mantle'AND (token_bought_symbol IN ('USDC','USDT')OR token_sold_symbol IN ('USDC','USDT'))AND block_time > NOW() - INTERVAL '30' day),total_trades AS (SELECTSUM(amount_usd) AS total_volumeFROM dex.tradesWHERE blockchain = 'mantle'AND block_time > NOW() - INTERVAL '30' day)SELECTstable_volume,total_volume,ROUND(stable_volume * 100.0 / total_volume, 2) AS stablecoin_share_pctFROM stable_trades, total_trades;