Query editor
SELECT 'boba' AS blockchain, t."from" AS tx_from, count_if(c."from" <> t."from") AS internal_contracts, count_if(c."from" = t."from") AS direct_contractsFROM boba.creation_traces cJOIN boba.transactions t ON t.hash = c.tx_hash AND t.block_number = c.block_numberWHERE c.block_month >= DATE '2015-01-01'AND c.block_month < DATE '2026-12-01'AND t.block_date >= DATE '2015-01-01'AND t.block_date < DATE '2026-11-09'GROUP BY 1, 2