Query editor
SELECTsymbol || '-' || project AS symbol_project,SUM(b.usd_value) AS usd_volume,COUNT(*) AS number_of_transfersFROM layerzero.messages aLEFT JOIN layerzero.transfers bON a.primary_key = b.messages_foreign_keyWHEREtype_transfer = 'oft'AND (source_chain = 'Etherlink'OR destination_chain = 'Etherlink')GROUP BYsymbol,projectORDER BYusd_volume DESC;