Query editor
WITH agg AS (SELECT DISTINCT tx_hashFROM dex_aggregator.tradesWHEREproject = '1inch'AND block_time >= NOW() - INTERVAL '{{DURATION}}' DAYAND ('{{CHAIN}}' = 'all' OR blockchain = '{{CHAIN}}')),dexes AS (SELECTtx_hash,CASEWHEN '{{DEX}}' != 'all' THEN project || ' ' || versionWHEN position('uniswap' IN project) > 0 THEN project || ' v' || versionWHEN position('sushiswap' IN project) > 0 THEN project || ' v' || COALESCE(CAST(TRY_CAST(version AS INTEGER) + 1 AS VARCHAR), version)ELSE replace(project, '_', ' ')END AS project,amount_usdFROM dex.tradesWHEREblock_time >= NOW() - INTERVAL '{{DURATION}}' DAYAND ('{{CHAIN}}' = 'all' OR blockchain = '{{CHAIN}}')AND ('{{DEX}}' = 'all' OR project = '{{DEX}}')),filtered_dex_trades AS (SELECT d.*FROM dexes dINNER JOIN agg a ON d.tx_hash = a.tx_hash)SELECTproject,SUM(amount_usd) AS total_amount_usdFROM filtered_dex_tradesGROUP BY projectORDER BY total_amount_usd DESC;