Query editor
SELECT count(*) AS n,count_if(substr(lower(m.addr_from), 3) = lower(to_hex(t."from"))) AS same_as_tx_sender,count_if(lower(m.addr_from) = lower(m.source_contract)) AS same_as_source_contract,count(DISTINCT m.addr_from) AS distinct_addr_fromFROM layerzero.messages mJOIN ethereum.transactions t ON t.hash = from_hex(substr(m.tx_hash_source, 3))WHERE m.ts_source >= TIMESTAMP '2026-11-01 00:00:00'AND m.ts_source < TIMESTAMP '2026-11-03 00:00:00'AND lower(m.source_chain) = 'ethereum'AND t.block_date >= DATE '2026-11-01'AND t.block_date < DATE '2026-11-04'