Query editor
WITH dln_orders AS (SELECTevt_block_date AS block_date,chain,'dln' AS source,evt_tx_hashFROM debridge_multichain.dlnsource_evt_createdorderWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),classic_bridge AS (SELECTevt_block_date AS block_date,chain,'classic' AS source,evt_tx_hashFROM debridge_multichain.debridgegate_evt_sentWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),combined AS (SELECT * FROM dln_ordersUNION ALLSELECT * FROM classic_bridge)SELECTblock_date,COUNT(DISTINCT evt_tx_hash) AS tx_count,COUNT(DISTINCT CASE WHEN source = 'dln' THEN evt_tx_hash END) AS dln_orders,COUNT(DISTINCT CASE WHEN source = 'classic' THEN evt_tx_hash END) AS classic_txsFROM combinedGROUP BY 1ORDER BY 1