Query editor
SELECTCOUNT(*) AS total_wxtz_transfers,SUM(COALESCE(b.usd_value, 0)) AS total_wxtz_volume_usdFROM layerzero.messages aLEFT JOIN layerzero.transfers bON a.primary_key = b.messages_foreign_keyWHEREb.type_transfer = 'oft'AND b.symbol = 'WXTZ';