Query editor
WITH per_route AS (SELECTsource_chain,destination_chain,COUNT(*) AS messages,SUM(COALESCE(usd_value, 0)) AS usd_volumeFROM layerzero.messagesWHEREsource_chain = 'Etherlink'OR destination_chain = 'Etherlink'GROUP BYsource_chain,destination_chain)SELECTSUM(messages) AS total_messages,SUM(usd_volume) AS total_usd_volumeFROM per_route;