Query editor
WITH pool_data AS (SELECTproject_contract_address,CASEWHEN project_contract_address = 0x365722f12ceb2063286A268B03c654Df81B7C00F THEN 'MNT-USDT'WHEN project_contract_address = 0x03BeafC0d25BB553fCa274301832419C05269987 THEN 'MNT-USDT0'WHEN project_contract_address = 0x5d54d430D1FD9425976147318E6080479bffC16D THEN 'USDe-MNT'WHEN project_contract_address = 0x1606C79bE3EBD70D8d40bAc6287e23005CfBefA2 THEN 'MNT-wETH'END AS pool_name,CASEWHEN project_contract_address = 0x365722f12ceb2063286A268B03c654Df81B7C00F THEN 0.0025WHEN project_contract_address = 0x03BeafC0d25BB553fCa274301832419C05269987 THEN 0.008WHEN project_contract_address = 0x5d54d430D1FD9425976147318E6080479bffC16D THEN 0.0025WHEN project_contract_address = 0x1606C79bE3EBD70D8d40bAc6287e23005CfBefA2 THEN 0.001END AS fee_tier,amount_usdFROM dex.tradesWHERE blockchain = 'mantle'AND project = 'merchant_moe'AND block_time >= NOW() - INTERVAL '7' DAYAND project_contract_address IN (0x365722f12ceb2063286A268B03c654Df81B7C00F,0x03BeafC0d25BB553fCa274301832419C05269987,0x5d54d430D1FD9425976147318E6080479bffC16D,0x1606C79bE3EBD70D8d40bAc6287e23005CfBefA2))SELECTpool_name,fee_tier,SUM(amount_usd) AS volume_7d,SUM(amount_usd * fee_tier) AS fees_7dFROM pool_dataGROUP BY 1, 2