Query editor
WITH fees AS (SELECTpool_name,fee_tier,SUM(amount_usd * fee_tier) AS lp_fees_1dFROM (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 '1' DAYAND project_contract_address IN (0x365722f12ceb2063286A268B03c654Df81B7C00F,0x03BeafC0d25BB553fCa274301832419C05269987,0x5d54d430D1FD9425976147318E6080479bffC16D,0x1606C79bE3EBD70D8d40bAc6287e23005CfBefA2))GROUP BY 1, 2),tvl AS (SELECT *FROM query_6698780)SELECTf.pool_name,f.fee_tier,f.lp_fees_1d,t.tvl_usd,FORMAT('%.2f%%', (f.lp_fees_1d / t.tvl_usd) * 365.0 * 100) AS fee_apr_1dFROM fees fLEFT JOIN tvl t ON f.pool_name = t.pool_nameORDER BY (f.lp_fees_1d / t.tvl_usd) * 365.0 * 100 DESC